Re: Postgres 7.3.5 and count('x')

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Edwin S(dot) Ramirez" <ramirez(at)idconcepts(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Postgres 7.3.5 and count('x')
Date: 2003-12-06 15:20:29
Message-ID: 13470.1070724029@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> What is COUNT('x') supposed to return? 1? Is that legal SQL?

Why not? Vanilla SQL would assume the string is CHAR type.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-12-06 15:31:36 Re: request for feedback - read-only GUC variables, pg_settings
Previous Message Mark Kirkwood 2003-12-06 11:40:54 Re: *sigh*