The following bug has been logged online:

Bug reference:      1522
Logged by:          DIEGO URRA
Email address:      [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system:   REDHAT 6.2
Description:        there's a syntax error using psql, distinct
Details: 

hi!

select distinct(id) from results; 
works fine

select distinct(id) || 'xyz' from results;
works fine

select 'abc' || distinct(id) || 'xyz' from resuls;
syntax error

is this a bug? thanks in advance
DIEGO URRA

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to