[GENERAL] Displaying a wide column with psql

2014-09-01 Thread Philip Rhoades
pg_dump, I couldn't see an interactive way of seeing the whole field. Is it possible? Thanks, Phil. -- Philip Rhoades GPO Box 3411 Sydney NSW 2001 Australia E-mail: p...@pricom.com.au -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Issue with CREATE EXTENSION tablefuncKreiter

2012-02-01 Thread Philip Rhoades
x86_64 was PostgreSQL 8.x - there were old (unused) versions of LedgerSMB - during the move from Fedora 14 to Fedora 16 (x86_64), the data was dumped out of PG 8.x and restored to PG 9.1P I haven't done any manual messing around with template1 as far as I know . . Regards, Phil. -- Philip

[GENERAL] PostgreSQL for Firefox Bookmarks?

2009-08-13 Thread Philip Rhoades
People, It would be nice to be able to use PostgreSQL as the storage for Firefox Bookmarks - anyone know if this would be possible? how it could be done? Thanks, Phil. -- Philip Rhoades GPO Box 3411 Sydney NSW 2001 Australia E-mail: p...@pricom.com.au -- Sent via pgsql-general

Re: [GENERAL] PostgreSQL for Firefox Bookmarks?

2009-08-13 Thread Philip Rhoades
Devrim, On 2009-08-14 00:55, Devrim GÜNDÜZ wrote: On Fri, 2009-08-14 at 00:20 +1000, Philip Rhoades wrote: It would be nice to be able to use PostgreSQL as the storage for Firefox Bookmarks - anyone know if this would be possible? how it could be done? Uh, I think it would consume more

[GENERAL] Subselects - recursion problem

2005-05-30 Thread Philip Rhoades
' AND c1.loc = c2.loc AND c1.lob = c2.lob AND c1.policy = c2.policy ) ORDER BY c1.loc, c1.lob, c1.policy ; -- Philip Rhoades Pricom Pty Limited (ACN 003 252 275 ABN 91 003 252 275) GPO Box 3411 Sydney NSW 2001 Australia Mobile: +61:0411-185

Re: [GENERAL] Subselects - recursion problem

2005-05-30 Thread Philip Rhoades
Martijn, On Mon, 2005-05-30 at 19:50, Martijn van Oosterhout wrote: On Mon, May 30, 2005 at 07:33:04PM +1000, Philip Rhoades wrote: People, The following script works (I have confirmed it by doing two separate views and doing a select on them) - but I don't understand why there isn't

Re: [GENERAL] Subselects - recursion problem

2005-05-30 Thread Philip Rhoades
Martijn, On Mon, 2005-05-30 at 21:08, Martijn van Oosterhout wrote: On Mon, May 30, 2005 at 08:32:15PM +1000, Philip Rhoades wrote: Martijn, On Mon, 2005-05-30 at 19:50, Martijn van Oosterhout wrote: recursion problem ? It's called a correlated subquery. SQL is declarative, you