Re: [GENERAL] select max from subquery

Oleg Bartunov wrote: > > yOn Sat, 14 Feb 2009, searchelite wrote: > >> >> Dear All >> >> i gave this kind of query >> >> select max(foo) from (select some statement) as foo >> >> but it gave me this error >> ERROR: function ma

[GENERAL] select max from subquery

Dear All i gave this kind of query select max(foo) from (select some statement) as foo but it gave me this error ERROR: function max(record) does not exist any help how i can select max value from suqbuery in main query thanks -- View this message in context: http://www.nabble.com/select-

Re: [GENERAL] auto insert data every one minute

Tino Wildenhain wrote: > > > I wonder what is you complete problem? It seems all the advices given > so far are shots-in-the-dark. Could you perhaps expand a bit? > > Also for sophisticated solution, if you stick to windows you might > want to consider something different then just pure CMD,

Re: [GENERAL] auto insert data every one minute

Daniel Verite wrote: > > searchelite wrote: > > > How about using pg_sleep ? > > INSERT ; > COMMIT; > SELECT pg_sleep(60); > > INSERT...; > COMMIT; > SELECT pg_sleep(60); > > > > i can use pg_sleep..but i have thousands of

[GENERAL] auto insert data every one minute

Hi all.. I have an sql script consists of insert statement data. I want to insert every row of data every one minute. How can i do that using batch file in windows Thank you -- View this message in context: http://www.nabble.com/auto-insert-data-every-one-minute-tp20027811p20027811.html Sent f

[GENERAL] Federated Server

Hi all.. Is there any capability of PostgreSQL to become a federated server? Thanks -- View this message in context: http://www.nabble.com/Federated-Server-tp19850547p19850547.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list

Re: [GENERAL] mirroring table

Craig Ringer wrote: > > It sounds like what you want is to have a table that contains a full > history of records, plus another table that contains only the records > from the first table that were inserted/updated today. > > If that is what you mean, there are several ways to do it, with > di

[GENERAL] mirroring table

Hi all..how can i mirroring table in postgresql? Let say i have a transaction table updated everyday, i want to mirror that table so that the other table only store the latest updated day records.. I hope you can understand my question.. Thanks in advance -- View this message in context: http:/