Title: RE: [SQL] Max Size of a text field
You can edit config.h and recompile 7.0.3 to allow for larger tuples (up to 32K - Info used to be in the FAQ but that has changed so try the mailing list archives for info) or you can try 7.1 RC1 or the CVS snapshot as both can deal with almost unlimit
Title: RE: [SQL] Help with 'now', now(), timestamp 'now', ...
try timeofday(), now() gives starttime of transaction :-{.
Regards
Ben
PS this has just been discussed in this mailing list or I would have been clueless
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL
Title: RE: [SQL] readline ??
Try the new RPMs: postgresql-7.0.3-2mdk. They include readline support.
Ben
> -Original Message-
> From: vs [mailto:[EMAIL PROTECTED]]
> Sent: 15 December 2000 10:12
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: [SQL] re
Title: RE: [SQL] to_char() causes backend to close connection
select to_char(now()-'5 minutes'::interval,'YYMMDDHH24MI') seems to work
Ben
> -Original Message-
> From: Kovacs Zoltan Sandor [mailto:[EMAIL PROTECTED]]
> Sent: 14 December 2000 15:49
> To: Karel Zak
> Cc: [EMAIL PROTEC
-
> From: kovacsz [mailto:[EMAIL PROTECTED]]
> Sent: 12 September 2000 10:23
> To: Zeljko Trogrlic
> Cc: Trewern, Ben; '[EMAIL PROTECTED]'
> Subject: Re: [SQL] Tree structure
>
>
> We are using tree structures (and partially ordered trees) with
> PostgreSQL.
Title: Tree structure
Anybody know how to make a tree structure using related tables using Postgres. Something like a directory structure is what I'm aiming for. I'm sure there is an easy way but I'm having probs.
Any help would be appreciated.
Ben.
