[SQL] Mag Gam

2013-07-20 Thread Mag Gam
http://faribradytattoo.dk/hhmqna/sninwzk.umbobbqmel Mag Gam 7/21/2013 7:22:12 AM -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] Curious about wide tables.

2008-04-27 Thread Mag Gam
Any chance this could be a view? On Sun, Apr 27, 2008 at 12:06 PM, Jonah H. Harris <[EMAIL PROTECTED]> wrote: > On Sun, Apr 27, 2008 at 9:01 AM, Jean-David Beyer > <[EMAIL PROTECTED]> wrote: > > In another thread, the O.P. had a question about a large table with over > 100 > > columns. Is this

Re: [SQL] Reg:-How to make relationship more one table in PgSQL

2008-04-29 Thread Mag Gam
http://www.w3schools.com/Sql/sql_join.asp hope this helps On Tue, Apr 29, 2008 at 7:21 AM, <[EMAIL PROTECTED]> wrote: > Hi Venkat, > > > > > > What kind of relation you want to create? Is it to do with the creation of > dependencies or something else? > > > > > > Regards, > > Kapil >

Re: [SQL] columns for count histograms of values

2008-04-30 Thread Mag Gam
Just curious, how are you planning to display the histogram? Are you allowed to use application code (C/C++/Perl, etc..) to generate the histogram? Personally, SQL is great for showing the data but not good for making graphs with data you can show. On Wed, Apr 30, 2008 at 5:01 PM, Alexy Khrabrov

[SQL] Difference in columns

2008-05-11 Thread Mag Gam
Hi All, I have a view that generates output similar to this. select * from foo.view; ts | size ---+- 2002-03-16| 11 2002-03-17| 16 2002-03-18| 18 2002-03-19| 12 I am trying to find the difference between the size column. So

Re: [SQL] Difference in columns

2008-05-11 Thread Mag Gam
Thanks all. I will try some of these suggestions. On Sun, May 11, 2008 at 3:58 PM, Craig Ringer <[EMAIL PROTECTED]> wrote: > Mag Gam wrote: > > > I am trying to find the difference between the size column. So the > > desired output would be > > >

Re: [SQL] Auto-formatting timestamps?

2008-05-13 Thread Mag Gam
Why not create a view? On Tue, May 13, 2008 at 11:58 AM, Peter Koczan <[EMAIL PROTECTED]> wrote: > Hi all, > > I'm undergoing a port from an old Sybase database to Postgres. It's > going surprisingly well, but I have a question regarding formatting of > timestamps. > > In Sybase, we get: > :> s

Re: [SQL] Auto-formatting timestamps?

2008-05-14 Thread Mag Gam
ch of them, sure its a lot of work, but its worth it HTH On Wed, May 14, 2008 at 11:46 AM, Peter Koczan <[EMAIL PROTECTED]> wrote: > On Tue, May 13, 2008 at 5:54 PM, Mag Gam <[EMAIL PROTECTED]> wrote: > > Why not create a view? > > That's a possibility, but the i