Re: [GENERAL] Default fill factor for tables?

2008-07-12 Thread Scott Marlowe
On Fri, Jul 11, 2008 at 5:53 PM, Simon Riggs <[EMAIL PROTECTED]> wrote: > > On Fri, 2008-07-11 at 15:25 -0600, Scott Marlowe wrote: >> On Fri, Jul 11, 2008 at 3:24 PM, Simon Riggs <[EMAIL PROTECTED]> wrote: >> > >> > On Fri, 2008-07-11 at 14:51 -0600, Scott Marlowe wrote: >> > >> >> I would kindly

Re: [GENERAL] Top N within groups?

2008-07-12 Thread hubert depesz lubaczewski
On Fri, Jul 11, 2008 at 01:24:28PM +1000, Klint Gore wrote: > Can someone familiar with the source for DISTINCT ON comment on how hard > it would be to add another parameter to return more than one row? you can make top-n per group quite easily using the technique described here: http://www.dep

[GENERAL] Wiki: FreeOpenSourceSoftware.org

2008-07-12 Thread Wm. Stewart
Hi PostgreSQL folks, I'm the author of the Internet site http://www.livinginternet.com/ with input from many of the original creators of the Internet. I was lucky enough to get the FreeOpenSourceSoftware and FreeLibreOpenSourceSoftware domains, and have donated them to the FOSS community.

[GENERAL] Relation not gfound in view Error

2008-07-12 Thread Michael Black
I created two tables populated both with valid data including forgien key values. I create a view that uses both of these tables in a view that. When I select from the view, I get this error ERROR: relation "vwsinglelevellist" does not existSQL state: 42P01 But when I run the defination as a

[GENERAL] Users functions library

2008-07-12 Thread Alejandro D. Burne
Hi, I need to write a function that gives me a password string, no just a numbers-characters string; something like people wrote in php, its based on determined syllables and numbers. I think it be useful to other people, is there a site where one can post it and share with other postgres users? A

Re: [GENERAL] Users functions library

2008-07-12 Thread Alejandro D. Burne
2008/7/12 Alejandro D. Burne <[EMAIL PROTECTED]>: > Hi, I need to write a function that gives me a password string, no > just a numbers-characters string; something like people wrote in php, > its based on determined syllables and numbers. > I think it be useful to other people, is there a site whe

Re: [GENERAL] Users functions library

2008-07-12 Thread Pavel Stehule
Hello safe it to pgfoundry http://pgfoundry.org/ regards Pavel Stehule 2008/7/13 Alejandro D. Burne <[EMAIL PROTECTED]>: > 2008/7/12 Alejandro D. Burne <[EMAIL PROTECTED]>: >> Hi, I need to write a function that gives me a password string, no >> just a numbers-characters string; something like p