Nevermind. It's late here and I'm not thinking clearly. Problem solved.
You're right, Tom. I'm sure someone has a use for a serial field that
isn't unique. I just assumed that it was. I guess I didn't read the
documentation closely enough. At any rate, I had a table using a serial
field that I had to restore to a previous date when I noticed that I
forgot to set th
Ferindo Middleton Jr <[EMAIL PROTECTED]> writes:
> Is there some reason why the SERIAL data type doesn't automatically have
> a UNIQUE CONSTRAINT.
It used to, and then we decoupled it. I don't think "I have no use for
one without the other" translates to an argument that no one has a use
for it
that query is 100% correct.
it’s just an equijoin (a type of
inner join) between 3 tables.
the syntax you show is how queries should
be written and is more
representative of what a joins between
relations really are:
Cartesian products with filters applied
the ansi syntax, the
> Is there supported syntax to do 'deep' queries? That is where
> A relates to B relates to C, returning fields from each table?
>
> This doesn't seem to work. Is there a google-able term for
> this sort of query?
>
> select
>foo.aaa,
>bar.bbb,
>baz.ccc
>
> from
>foo,bar,baz
>
Is there some reason why the SERIAL data type doesn't automatically have
a UNIQUE CONSTRAINT. It seems that the main reason for using it is so
that the value for this field keeps changing automatically and is never
null so any one record can be identified using it- So why not imply that
it is a
Is there supported syntax to do 'deep' queries? That is where A relates to B relates to C, returning fields from each table?
This doesn't seem to work. Is there a google-able term for this sort of query?
select
foo.aaa,
bar.bbb,
baz.ccc
from
foo,bar,baz
where
foo.bar_id = bar.i
Brandon Metcalf wrote:
> Is there a way to check for the existence of a column in a table
> other than, say, doing a SELECT on that column name and checking the
> output?
SELECT * FROM information_schema.columns;
Customize to taste.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
On Mon, Sep 26, 2005 at 12:34:59PM +0200, Axel Rau wrote:
> Am 26.09.2005 um 02:05 schrieb Michael Fuhr:
> > On Fri, Sep 23, 2005 at 09:19:25PM +0200, Axel Rau wrote:
> > > I'm sure this would be the cleanest solution but remember networks
> > > change.
> >
> > Yes, which is why it's a good idea to
Is there a way to check for the existence of a column in a table other
than, say, doing a SELECT on that column name and checking the output?
I'm basically looking to do an ALTER TABLE foo ADD COLUMN bar if bar
doesn't exist.
Thanks.
--
Brandon
---(end of broadcast)
[EMAIL PROTECTED] writes:
> Is it possible to delete a record from all tables in the database at
> the same time, without having to execute a separate "DELETE" statement
> for each table?
>
> I have a situation where I need to delete user records from our system.
> The user account information is s
Am 26.09.2005 um 02:05 schrieb Michael Fuhr:
On Fri, Sep 23, 2005 at 09:19:25PM +0200, Axel Rau wrote:
Am 23.09.2005 um 19:32 schrieb Michael Fuhr:
On Fri, Sep 23, 2005 at 06:31:17PM +0200, Axel Rau wrote:
Networks change during time, being diveded or aggregated or you just
enter wrong data
12 matches
Mail list logo
