Postgres 7.3.5 and count('x')

From: ramirez(at)idconcepts(dot)org (Edwin S(dot) Ramirez)
To: pgsql-hackers(at)postgresql(dot)org
Subject: Postgres 7.3.5 and count('x')
Date: 2003-12-02 18:52:17
Message-ID: 8d9c3e20.0312021052.75cd6b7@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

It appears that the count('x') will no longer work without a type
cast. Is this on purpose? I've already modified my code to use
count(*) instead, but I decided to mention it anyway.

warehouse=# select count('x') ;
ERROR: cannot accept a value of type any
warehouse=# select count('x'::text) ;
count
-------
1
(1 row)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2003-12-02 18:56:04 Re: [pgsql-hackers-win32] What packages from Mingw and MSys are needed?
Previous Message Lamar Owen 2003-12-02 18:42:51 Re: rebuilding rpm for RH9 error