Re: [GENERAL] [NOVICE] Question About Aggregate Functions

2006-09-13 Thread Brandon Aiken
Subject: Re: [GENERAL] [NOVICE] Question About Aggregate Functions   On 9/13/06, Brandon Aiken <[EMAIL PROTECTED]> wrote: Ah, I did not know what was in your fields, so I did not assume they were Boolean values.  It looked to me like you were trying to use IS TRUE to substitute for t

Re: [GENERAL] [NOVICE] Question About Aggregate Functions

2006-09-13 Thread Don Parris
On 9/13/06, Brandon Aiken <[EMAIL PROTECTED]> wrote: Ah, I did not know what was in your fields, so I did not assume they were Boolean values.  It looked to me like you were trying to use IS TRUE to substitute for the lack of a GROUP BY, so I didn't know what to do.That was in the fi

Re: [GENERAL] [NOVICE] Question About Aggregate Functions

2006-09-13 Thread Brandon Aiken
Ah, I did not know what was in your fields, so I did not assume they were Boolean values.  It looked to me like you were trying to use IS TRUE to substitute for the lack of a GROUP BY, so I didn’t know what to do.   Yes, count() will include all non-NULL values.  Sorry if I sounded unclea

Re: [GENERAL] Novice Question

2005-03-01 Thread Edmund Bacon
[EMAIL PROTECTED] (Michael Romagnoli) writes: > What kind of command would I run if I wanted to copy an entire table > (along with renaming it, and, of course, all data from the first table > - > some of which is binary)? SELECT * INTO newtable FROM oldtable; Note that this doesn't construct ind

Re: [GENERAL] Novice Question

2005-03-01 Thread Chris Kratz
create database newdb template olddb; works as well. -Chris On Tuesday 01 March 2005 05:08 pm, javier wilson wrote: > On Tue, 01 Mar 2005 16:30:19 -0500, Michael Romagnoli > > <[EMAIL PROTECTED]> wrote: > > Sorry, I meant to ask about copying databases, not tables (including all > > data in th

Re: [GENERAL] Novice Question

2005-03-01 Thread javier wilson
On Tue, 01 Mar 2005 16:30:19 -0500, Michael Romagnoli <[EMAIL PROTECTED]> wrote: > > Sorry, I meant to ask about copying databases, not tables (including all > data in the database as per below). you can do a pg_dump your_database>your_database.dump.sql and then createdb to create your new datab

Re: [GENERAL] Novice Question

2005-03-01 Thread Bricklen Anderson
Sean Davis wrote: On Mar 1, 2005, at 4:23 PM, Michael Romagnoli wrote: I am new to postgresql, having previously worked with mysql mostly. What kind of command would I run if I wanted to copy an entire table (along with renaming it, and, of course, all data from the first table - some of which is

Re: [GENERAL] Novice Question

2005-03-01 Thread Sean Davis
On Mar 1, 2005, at 4:23 PM, Michael Romagnoli wrote: I am new to postgresql, having previously worked with mysql mostly. What kind of command would I run if I wanted to copy an entire table (along with renaming it, and, of course, all data from the first table - some of which is binary)? Thanks,

Re: [GENERAL] Novice Question

2005-03-01 Thread Michael Romagnoli
Sorry, I meant to ask about copying databases, not tables (including all data in the database as per below). Thanks, -Mike Michael Romagnoli wrote: I am new to postgresql, having previously worked with mysql mostly. What kind of command would I run if I wanted to copy an entire table (along with

[GENERAL] Novice Question

2005-03-01 Thread Michael Romagnoli
I am new to postgresql, having previously worked with mysql mostly. What kind of command would I run if I wanted to copy an entire table (along with renaming it, and, of course, all data from the first table - some of which is binary)? Thanks, -Mike ---(end of broadcast)-