Re: [GENERAL] This works in 7.2.1, not in 7.3.2

2003-07-11 Thread Tom Lane
"Frank Millman" <[EMAIL PROTECTED]> writes: > The following works in 7.2.1 - > 1. select count(*) from SysUsersCompanies where UserRowId =3D 3 ; > 2. select substring('NY',(select count(*) from SysUsersCompanies where User= > RowId =3D 3)+1,1) ; > The first select returns either 1 or 0 > The seco

Re: [GENERAL] This works in 7.2.1, not in 7.3.2

2003-07-11 Thread Stephan Szabo
On Thu, 10 Jul 2003, Frank Millman wrote: > 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 > T

[GENERAL] This works in 7.2.1, not in 7.3.2

2003-07-11 Thread Frank Millman
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 _expre