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
|
- Re: [GENERAL] This works in 7.2.1, not in 7.3.2 Frank Millman
- Re: [GENERAL] This works in 7.2.1, not in 7.3.2 Stephan Szabo
- Re: [GENERAL] This works in 7.2.1, not in 7.3.2 Tom Lane