BUG #1522: there's a syntax error using psql, distinct

From: "DIEGO URRA" <diegomann(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1522: there's a syntax error using psql, distinct
Date: 2005-03-03 19:15:27
Message-ID: 20050303191527.50982F14B7@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1522
Logged by: DIEGO URRA
Email address: diegomann(at)yahoo(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sergio Lob 2005-03-03 21:24:19 BUG #1523: precision column value returned from getTypeInfo() always has value 9
Previous Message Sergio Lob 2005-03-03 17:36:54 BUG #1521: precision column value returned from getTypeInfo() always value of 9