This works in 7.2.1, not in 7.3.2

From: "Frank Millman" <frank(at)chagford(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: This works in 7.2.1, not in 7.3.2
Date: 2003-07-10 08:07:04
Message-ID: 000c01c346ba$415189f0$0401a8c0@chagford
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all

The following works in 7.2.1 -

1. select count(*) from SysUsersCompanies where UserRowId = 3 ;
2. select substring('NY',(select count(*) from SysUsersCompanies where UserRowId = 3)+1,1) ;

The first select returns either 1 or 0
The second one uses the result in a more complex expression, and returns either 'Y' or 'N'

In 7.3.2, the first select behaves the same, but the second one returns NULL.

Any advice will be appreciated.

Frank Millman

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2003-07-10 08:19:21 Re: Dynamic plpgsql code
Previous Message icaplovic 2003-07-10 08:01:25 PostgreSQL, Cygwin - setting locales