Re: [SQL] Rollback in Postgres

e. Stuff that they see fit to add is > not necessarily going to be on our radar screen in the foreseeable > future. I wasn't proposing to add it in 8.4. Just to add it to the TODO. Perhaps someone would look at it some point in the future. -- Med venlig hilsen Kaa

Re: [SQL] Rollback in Postgres

me travel feature that was removed because it made Postgres too slow to use in production? -- Med venlig hilsen Kaare Rasmussen, Jasonic Jasonic Telefon: +45 3816 2582 Nordre Fasanvej 12 2000 Frederiksberg Email: [EMAIL PROTECTED] -- Sent via pgsql-sql mailin

Re: [SQL] Rollback in Postgres

o Postgres' vacuum it would be rather cheap to make, I recon. I wouldn't worry about query speed as I guess that the use cases for retrieving already deleted rows don't aren't performance dependant. -- Med venlig hilsen Kaare Rasmussen, Jasonic Jasonic Telef

Re: [SQL] Rollback in Postgres

. I don't say it's an important feature, but it would come in handy for people who really really need it. And perhaps a developer wouldn't mind scratching this itch some time in the future. -- Med venlig hilsen Kaare Rasmussen, Jasonic Jasonic Telefon: +45 3816

Re: [SQL] Scheduling Jobs In PostgreSQL

> Is it possbile to schedule jobs in postgres? I believe that the correct answer would be: Yes, it is possible, but No you wouldn't want to do that. A scheduler for PostgreSQL colud be written in Perl, but a much better idea would to use cron or another external scheduler. -- Kaare R

Re: [SQL] to_number

So it seems that PostgreSQL can handle one and only one locale setting per installation. Hmmm. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Em

[SQL] to_number

82-4'; price | to_number ---+--- 429,5 | 4295 429,5 | 4295 429,5 | 4295 429,5 | 4295 429,5 | 4295 429,5 | 4295 429,5 | 4295 429,5 | 4295 429,5 | 4295 429,5 | 4295 (10 rows) How can to_number work with Danish locale? -- Kaare Rasm

Re: [GENERAL] [SQL] Database Design tool

> Thanks. This gives me a few more tools to look at. Boy, do we have an > answer for the folks who complain "there are no GUI tools for Postgres". While there are a number of GUI tools for PostgreSQL, there's still no real database design tool like ErWin or so.

Re: [SQL] number of days in a month

> does it exist a date function to determine the number of days in a > Select, knowing a specifique date ? January, 2001: select '2001-2-1'::datetime - '2001-1-1'::datetime; -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki D

Re: [SQL] PostgreSQL HOWTO

> I do not see how it puts the Postgres community in a bad light, although I > do see how the author is a moron. People think that it's an official PostgreSQL document. It turned up in a discussion (PostgreSQL vs. MySQL round 1000) as "the PostgreSQL docs".

[SQL] PostgreSQL HOWTO

Whoever wrote this is putting the PostgreSQL community in a bad light: http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-4.html Maybe someone can change the document, or make the author change it? -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Data

Re: [SQL] new serial type

Den lørdag 13. januar 2001 11:42 skrev Rolf Johansson: > Is there some function to change the serial type to, instead of reading > a next-value, read the maxium value in a column and then add x? If, for You can use setval(sequence, number) and MAX(number) in combination. -- Kaare Ras

Re: [HACKERS] Re: [SQL] PostgreSQL web page

t was an important news item for PostgreSQL, but I may of course be wrong! -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECT

[SQL] PostgreSQL web page

html - but you can see it if you write the correct URL yourself. -- Kaare Rasmussen --Linux, spil,--Tlf:3816 2582 Kaki Data tshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED] 2000 Frederi

Re: [SQL] Date/Time problem -(((

lounge/docs/7.0/postgres/functions2876.htm -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLør

[SQL] 7.1 feature?

regation, or sorting in a single query. Is this a 7.1 feature? Or is my typing wrong? And will 7.1 support unions in subselects like above? -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitz

Re: [SQL] Running a file

> Are you talking about writing external scripts and importing them into > Postgres in a manner similar to the @ function in SQL*Plus? In psql, you > can use \i to import scripts to do that. If it's to be used in shell scripts, it's just as easy to pipe: psql dbname

Re: [SQL] Invoice number

n cancelled. But I have a feeling my accountant doesn't agree :-) -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED] 20

[SQL] Invoice number

Hi My, my. It works. How many times have I tried this mailing list with no success :-( I'm wondering how people creates guaranteed sequential numbers - in my case for invoice numbers. - Sequences are not rollback'able. - It seems overkill to have a table just for this. - What else? tia

[SQL] test

x -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 11.00-17.00 Web