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

Re: Where is the error

From: Kaloyan Iliev Iliev <news1(at)faith(dot)digsys(dot)bg>
To: John DeSoi <desoi(at)pgedit(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Where is the error
Date: 2004-12-27 12:30:56
Message-ID: 41D00080.4060004@faith.digsys.bg (view raw or flat)
Thread:
Lists: pgsql-general
10x John,

You are right.The problem is that the function was dumped with quotes 
from pg_dump but I suppose the one who created it used quotes and that's 
why it dumps in this way.
I will fix this in the dump.

Thanks again.

     Kaloyan

John DeSoi wrote:

>
> On Dec 27, 2004, at 6:42 AM, Kaloyan Iliev Iliev wrote:
>
>> CREATE OR REPLACE FUNCTION "int" (boolean) RETURNS integer AS'
>> select CASE WHEN $1 THEN 1
>> ELSE 0
>> END
>> 'LANGUAGE 'sql';
>>
>
> The problem is that you have quoted the function name as "int". You 
> should only do this when you want to force the exact case of the name. 
> When you do it this way, you have to use double quotes when you refer 
> to the identifier:
>
>
> select "int"('t'::boolean);
>  int
> -----
>    1
> (1 row)
>
>
> So in this case you probably want to call your function int -- without 
> quotes. By default, PostgreSQL folds the names to lowercase.
>
>
> Best,
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
>

In response to

pgsql-general by date

Next:From: Andreas KretschmerDate: 2004-12-27 12:31:53
Subject: Re: Where is the error
Previous:From: Marek LewczukDate: 2004-12-27 12:25:55
Subject: Re: Where is the error

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