sql
> programming style? faster?
Better style, yes. Whitespace would help also.
Faster, maybe. If you use join clauses you will be able to take control
over your query, specifying what gets joined when.
--
Alan Gutierrez - [EMAIL PROTECTED]
http://khtml-win32.sourceforge.n
dards,
so posting using the standard is his way of boosting them.
BEGIN ATOMIC is BEGIN in PG.
I am not sure how to declare a variable in PG in normal SQL. I don't do
it that often, but when I do I do this:
CREATE TEMPORARY TABLE Rightmost_Spread
AS SELECT rightmost_spread
FROM Fram
ql with the -E argument to see
the SQL used to run \dt. Look at man psql for for info for just:
psql -E template1
Alan Gutierrez
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
to debate C++
here! Its just that C++ is what made my knee jerk.
Thanks for showing me the value of operator overloading in PostgreSQL.
Alan
On Tue, 14 Aug 2001, Ross J. Reedstrom wrote:
> On Tue, Aug 14, 2001 at 06:51:33AM +, Alan Gutierrez wrote:
> >
> > Overloading operato
So an attempt to
>
> UPDATE t1 SET id = 2 WHERE id = 1;
>
> is the thing prevented in your above example.
I find it odd that you specify a restiction on one table in the definition of
another table.
Sorry, if this was a double post.
Alan Gutierrez
--
