Re: [SQL] Maximum length of a query

On Wed, Feb 09, 2005 at 11:43:20AM +0530, Antony Paul wrote: > > What is the maximum length allowed for a query in PG 7.3.3 ?. I > need arbitrarily long queries to be executed through JDBC. According to the following message from Tom Lane, "There is no specific limit; it'll depend on available

[SQL] How to know a temp table exists ?

Hi all, If using a connection pool how to know a temp table exists ? rgds Antony Paul ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [SQL] Updating selected record

On Feb 8, 2005, at 9:05 AM, Levente Lajko wrote:   I have problem with a table from where I select specific field data SELECT filed1, field2 FROM tbl WHERE progress = 1 LIMIT 1  through a perl script or multiple instances of that script. The script sets the progress value of the progressed recor

[SQL] Maximum length of a query

Hi all, What is the maximum length allowed for a query in PG 7.3.3 ?. I need arbitrarily long queries to be executed through JDBC. rgds Antony Paul ---(end of broadcast)--- TIP 8: explain analyze is your friend

[SQL] Updating selected record

Hi,   I have problem with a table from where I select specific field data SELECT filed1, field2 FROM tbl WHERE progress = 1 LIMIT 1  through a perl script or multiple instances of that script. The script sets the progress value of the progressed record to 0, so that other processes not

[SQL] the best way to get the first record from each group

Hi, Is there any better alternative to get the first record from each group? "subno" is an integer, record with the smallest subno in each group is the first record in the group. select itemno, measureunit, extaxprice from itmt_purchase where subno in (select min(subno)as subno from itmt_pu

[SQL] Can tsearch replace ilike queries ?

Hi all, I read in another thread about using tsearch for ilike queries. My question is can it rprovide the full ilike functionality with a better performance than ilike ?. rgds Antony Paul ---(end of broadcast)--- TIP 8: explain analyze is your

[SQL] 8 rpms for red hat

I was able to download the ES3 version (we are running AS3). I could get (without installing 7) the server to install and run. I had a few of the RPM's complain (the lib one for example). I was not sure if this was a needed rpm as I could start the server (did not try to load data, but will do that

[SQL] Did a good restore

I just wanted to thank those who helped me. I finally hit it on the head, was the SQL_ASCHII versus UNICODE.   I am not sure why I got my original database in SQL_ASCHII, but when I did my create with it and restored to it it was fine. I am going to try my create with UNICODE (the defau