Re: [SQL] Substring

2009-09-07 Thread Fernando Hevia
> > > > Given that tablename is "voipdb"; I wonder if OP really > wants to write > > a query that finds the row where argument to function > matches the most > > number of leading characters in "prefix". > > > > If voipdb table contains: ab, abc, def, defg; then calling > function > > wit

[SQL] Postgresql PostGIS installation on Widows Server 2003

2009-09-07 Thread venkat
Dear All, I am using Windows Server 2003 for installing Postgresql 8.1. I got error called "Filed to set permissions on installed files".And i have uninsulated 8.1 and i try to install 8.2. Here also I am getting same error.When try to install Postgresql 8.3, It is installed but i am not able t