[GENERAL] Nulls in timestamps

Where does PostgreSQL rank nulls when sorting a column of timestamps, is this behaviour deterministic, and can I rely on it not changing in the future? Apologies if this shows up as a repost, I've had gateway problems at this end. -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk

Re: [GENERAL] Nulls in timestamps

Many thanks Tom. Inconvenient from the point of view of the application but still useful information. The situation is that I've got a query with numerous subselects, each of which has to return exactly one row so I was doing a union with a nulled record then selecting the most recent: obviously

Re: [GENERAL] Migration

Justin Clift wrote: Did you get any feedback on this? :-) Unfortunately not, but I live in hope. [If you live in Hope, you'll die in Caergwrle]. I can afford very little time to play with it at present, however I'll come back to it as soon as I can since one of our ongoing issues is trying to

Re: [GENERAL] html to postgres...

I'm successfully storing -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister

Re: [GENERAL] html to postgres...

Tony Grant wrote: These are film and director pages in a movie site. I am looking at HTML-XML tools then with a parser I should be able to create a tab delimited text file. I'm successfully storing scripts in tables which are pulled and executed on a client system, works well so far except

Re: [GENERAL] 2 gig file size limit

Marco Colombo wrote: BTW, the document contains some limits. FS size limit is reported to be 2TB (block-device size limit). I don't know if it applies to LVM logical volumes. Ext2 FS size limit is 16TB (for 4kB blocks FS). You need to put some effort to place 16TB on a single FS. Thanks for

Re: [GENERAL] 2 gig file size limit

Martijn van Oosterhout wrote: What the limit on NT? I'm told 2^64 bytes. Frankly, I'd be surprised if MS has tested it :-) -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] ---(end of

Re: [GENERAL] 2 gig file size limit

Can a single database be split over multiple filesystems, or does the filesystem size under e.g. Linux (whatever it is these days) constrain the database size? -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues]

Re: [GENERAL] 2 gig file size limit

Ian Willis wrote: Postgresql transparently breaks the db into 1G chunks. Yes, but presumably these are still in the directory tree that was created by initdb, i.e. normally on a single filesystem. The main concern is during dumps. A 10G db can't be dumped if the filesustem has a 2G limit.