There are two select statement with using Function chr(0), I don't know, are
they both right ? I think that they are inconsistent.
Thanks
[EMAIL PROTECTED] ~]$ psql
Welcome to psql 8.1.3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
postgres=# select 'abc' || chr(0) || 'abc' as col;
col
-----
abc
(1 row)
postgres=# select length('abc' || chr(0) || 'abc') as col;
col
-----
7
(1 row)
----------------------------------------------------------------------------------------------
Confidentiality Notice: The information contained in this e-mail and any
accompanying attachment(s) is intended only for the use of the intended
recipient and may be confidential and/or privileged of Neusoft Group Ltd., its
subsidiaries and/or its affiliates. If any reader of this communication is not
the intended recipient, unauthorized use, forwarding, printing, storing,
disclosure or copying is strictly prohibited, and may be unlawful. If you have
received this communication in error, please immediately notify the sender by
return e-mail, and delete the original message and all copies from your system.
Thank you.
-----------------------------------------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
