Re: [GENERAL] Query output into a space delimited/location sensitive file

2008-02-16 Thread Ubence Quevedo
at 04:12 PM, Scott Marlowe wrote: On Feb 16, 2008 5:29 PM, Bruce Momjian <[EMAIL PROTECTED]> wrote: Ubence Quevedo wrote: What would the command be to have a query result be put into a location/space sensitive file [position 1 through 5 would be one thing where position 6 through 10 w

[GENERAL] Query output into a space delimited/location sensitive file

2008-02-15 Thread Ubence Quevedo
What would the command be to have a query result be put into a location/space sensitive file [position 1 through 5 would be one thing where position 6 through 10 would be the next field, 11 through 16 another, etc]? Is this even possible with Postgres? ---(end of br

[GENERAL] Correct way to set up Variables [Was - Simple Accumulating Number Loop?]

2005-12-30 Thread Ubence Quevedo
seems like an awful lot to do [or does MS SQL make it easier than PostgreSQL?]. Any help, ideas, or clarification are much appreciated. -Ubence > --- Ubence Quevedo <[EMAIL PROTECTED]> wrote: > > > Date: Thu, 29 Dec 2005 15:26:07 -0800 (PST) > > From: Ubence Quevedo &l

[GENERAL] Simple Accumulating Number Loop?

2005-12-29 Thread Ubence Quevedo
A friend of mine has created this simple accumulating loop query for MS SQL 2k5 Express Edition. I am trying to reproduce the same results with PostgreSQL 8.1, but am not able to find much useful help on how to properly set up a variable of both int and char. The PostgreSQL documentation is great