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(at)pgsql(dot)com | jeff(at)hub(dot)org
www.pgsql.com | www.hub.org
1-902-542-0713 | 1-902-542-3657
-----------------------------------------------------
Facsimile : 1 902 542 5386
IRC Nick : bignose