Re: [SQL] psql question

2000-11-23 Thread bmccoy
http://www.chapelperilous.net/~bmccoy/ --- Criticism comes easier than craftsmanship. -- Zeuxis

Re: [SQL] Create tables in one query

2000-11-23 Thread bmccoy
.. ; in a single file and load the file into psql via \i. That's I build all of my databases. Brett W. McCoy http://www.chapelperilous.net/~bmccoy/ --- A bachelor is a selfish, u

Re: [SQL]

2000-10-23 Thread bmccoy
On Mon, 23 Oct 2000 [EMAIL PROTECTED] wrote: > I have following problem with PostgreSQL 6.5.3, I haven't possiblity > to check it on 7.0 and I want to know is it possible to run such query: > > SELECTk.pic, id_g, id_k, count(*) What table do these come fr

Re: [SQL] COUNT

2000-10-19 Thread bmccoy
On Fri, 20 Oct 2000, Craig May wrote: > How do I get a row count, like "Select [COUNT] from Table" ?? SELECT COUNT(*) FROM Brett W. McCoy http://www.chapelperilous.net --- Man

Re: [SQL] table as field type??

2000-10-03 Thread bmccoy
On Wed, 4 Oct 2000, Tod McQuillin wrote: > > I noticed that it's possible to have a table as a field type. > > For example: > > create table foo (val1 integer); > > create table bar (val2 foo); > > > > val2 in table bar ends up as an int4, designed for storing an oid from > > table foo. > > Is