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

Where is the error

From: Kaloyan Iliev Iliev <news1(at)faith(dot)digsys(dot)bg>
To: pgsql-general(at)postgresql(dot)org
Subject: Where is the error
Date: 2004-12-27 11:42:07
Message-ID: 41CFF50F.5080606@faith.digsys.bg (view raw or flat)
Thread:
Lists: pgsql-general
Hi
  I have the following function:

CREATE OR REPLACE FUNCTION "int" (boolean) RETURNS integer AS'
select CASE WHEN $1 THEN 1
ELSE 0
END
'LANGUAGE 'sql';

When I try to use it:

select int('t'::bool);
ERROR:  syntax error at or near "(" at character 11

I am using PG8.0b1

Thank you.

      Kaloyan



Responses

pgsql-general by date

Next:From: Martijn van OosterhoutDate: 2004-12-27 12:07:07
Subject: Re: Get current trasanction id
Previous:From: Achilleus MantziosDate: 2004-12-27 10:38:33
Subject: Re: [SQL] Get current trasanction id

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