Home > mailing lists

This works in 7.2.1, not in 7.3.2 - Mailing list pgsql-general

From	Frank Millman
Subject	This works in 7.2.1, not in 7.3.2
Date	July 11, 2003 22:29:25
Msg-id	000c01c346ba$415189f0$0401a8c0@chagford Whole thread Raw
Responses	Re: This works in 7.2.1, not in 7.3.2 (Stephan Szabo <sszabo@megazone23.bigpanda.com>) Re: This works in 7.2.1, not in 7.3.2 (Tom Lane <tgl@sss.pgh.pa.us>)
List	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

From: Justin Tocci
Date: 11 July 2003, 17:57:04
Subject: Complex rules and working with MS Access: SOLVED

From: "Zeno R.R. Davatz"
Date: 11 July 2003, 22:29:57
Subject: corrupt data