Re: [SQL] Problem with SQL stored procedure

2006-12-08 Thread Shoaib Mir
Wrong mailing list to ask this :-) Try out a MS SQL Server one and you will get good help on that... Regards, Shoaib On 12/8/06, sid tow <[EMAIL PROTECTED]> wrote: Hi all I dont know if this is the right forum to post this but any way if you could help me or guide me to an appropriate

Re: [SQL] problem with sql

2003-10-25 Thread Michael Glaesmann
Hi Adam, On Monday, Oct 20, 2003, at 01:56 Asia/Tokyo, Adaƛ wrote: status. I made a query using LAST and GROUP BY to select last order for each customer and I wanted to use it in UPDATE query, but it seems to be impossible. I don't believe PostgreSQL has a built-in function similar to MS Access

Re: [SQL] Problem with SQL query (eats swap)

2000-08-11 Thread Tom Lane
[EMAIL PROTECTED] (Mailing List Expander) writes: > select count(*) from attachments a where a.id in (select m.id from > mail m where m.date < now()-62); > but ran out of swap. The problem is that "now()-62" leaks memory to the tune of a few dozen bytes per evaluation. In existing releases that