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

Re: True/False Values

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Dean Grubb <dean(at)atrium-online(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: True/False Values
Date: 2002-07-29 02:50:14
Message-ID: 200207290250.g6T2oEe09697@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Two servers of the same release calling the same function and one
returns 0/1 and another f/t.  Seems impossible to me.  There must be
some difference between the servers.

---------------------------------------------------------------------------

Dean Grubb wrote:
> Hi,
> 
> I have two different postgresql 7.1.3 servers, when I return a true or false
> value from a PL/pgSQL function one server returns  0 or 1 but the other
> returns 'f' or 't'.
> 
> Is this a configuration setting some where?
> 
> Dean Grubb
> Atrium-Online
> www.atrium-online.com.au

[ unknown/unknown is not supported, skipping... ]

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-general by date

Next:From: Alex Cheung Tin KaDate: 2002-07-29 02:51:44
Subject: Fw: questions in query on 7.1 and 7.2
Previous:From: Stephan SzaboDate: 2002-07-29 02:13:52
Subject: Re: questions in query on 7.1 and 7.2

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