Postgres Pro
Downloads
Home   >   mailing lists

BUG #1522: there's a syntax error using psql, distinct - Mailing list pgsql-bugs

From DIEGO URRA
Subject BUG #1522: there's a syntax error using psql, distinct
Date
Msg-id 20050303191527.50982F14B7@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1522: there's a syntax error using psql, distinct  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      1522
Logged by:          DIEGO URRA
Email address:      diegomann@yahoo.com
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

pgsql-bugs by date:

Previous
From: "Al Torres"
Date:
Subject: BUG #1519: server closed the connection unexpectedly
Next
From: Stephan Szabo
Date:
Subject: Re: BUG #1522: there's a syntax error using psql, distinct