i noticed that substr behaves a bit different in pgsql than perl
ie select foo from table where substr(foo,1,1) = 'X';
initially i thought it should be substr(foo,0,1)
just wondering on the reasoning for this offset ?
Jeff MacDonald,
-----------------------------------------------------
PostgreSQL Inc | Hub.Org Networking Services
jeff@pgsql.com | jeff@hub.org
www.pgsql.com | www.hub.org
1-902-542-0713 | 1-902-542-3657
-----------------------------------------------------
Facsimile : 1 902 542 5386
IRC Nick : bignose