Re: [BUGS] Something strang on "left join" - Mailing list pgsql-bugs

From Tomas Vondra
Subject Re: [BUGS] Something strang on "left join"
Date
Msg-id 41d09a92-9934-d3e8-2eb9-cf40d0fa537b@2ndquadrant.com
Whole thread Raw
In response to Re: [BUGS] Something strang on "left join"  (jeanpierre.carayol@free.fr)
List pgsql-bugs
On 09/28/2017 12:01 PM, jeanpierre.carayol@free.fr wrote:
> I also suspect the ID columns values for lines identified by CUST-NO.
> 
> Sorry to ask an additionnal question here. There is a useful Oracle
> function dump()
> <https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions048.htm#SQLRF00635>
> to check the internal field value. Is there anything similar with
> PostgreSQL ?
> 

I don't think there's anything like that in PostgreSQL directly, but you
could use "orafce" extension [1] which provides various functions
available on Oracle, including dump().

[1] https://github.com/orafce/orafce

But you could also use 'quote_ident()' which simply quotes the value, so
any additional spaces are quite obvious.

Or even better - fix the schema and make the fields INT or BIGINT, which
will make the fields both more efficient and resilient to such issues.


regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [BUGS] BUG #14833: Row security policies using session variablecan be circumvented
Next
From: Tomas Vondra
Date:
Subject: Re: [BUGS] BUG #14835: Postgres crashed