Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group