Hey Mike Cox, leave my fucking lists alone you trouble making racist homophobic
son of bitch!
Screw your mother, pussy!
Marc G. Fournier
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unre
CUM-SWALLOWING MIKE COX is FUCKING UP THIS LIST!
FUCK YOU, BITCH
Peter Eisentraut
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Nov 11, 2004, at 4:54 PM, Greg Stark wrote:
In case anyone's curious, this looks like the work of the well known
net.kook,
Steve Young <[EMAIL PROTECTED]>.
Thanks for looking this up, Greg. I, for one, was indeed curious.
Michael
grzm
---(end of broadcast)---
SPANKARD LIONEL, GO FUCK YOURSELF YOU gOOkFUCKER!
We're havin a *knee* *slappin* great time!
:)
Come join the fun ;)
Bwahahahahaha!
Greg Stark
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Thu, Nov 11, 2004 at 08:13:16AM +0100, Bjoern Platzen wrote:
> insert into "T_OEPNV_HST_LIN" ("HST_NR", "LIN_U_NAME", "LIN_KAT",
> "LIN_NAME_O", "LIN_NAME_I") values ('10001', 'Stadtwerke Marburg GmbH',
> 'Bus', 'C', '11103');
> does not work while
> select * from "T_OEPNV_HST" where "HST_NR
I asked:
Naively I imagined that ANALYSE looks at each table in turn,
independently. So why does it need more locks when there are more
tables?
Tom replied:
7.4 runs a database-wide ANALYZE as a single transaction, so the locks
accumulate. This was recognized to be a bad idea :-(. 8.0 is a bit
Hi Kevin,
I'm probably a bit more concerned about this than you are... I don't
want to have to post anonymously just to protect my email address...
That is precisely why I stopped using Usenet about 5 years ago - it just
got overwhelming...
I hope the owner of this list considers this issue very
GUY MACON
6158 Flamingo Drive
Buena Park, CA 90620-1328
714-670-1687 714-310-2574
http://www.guymacon.net
[EMAIL PROTECTED]
He is a fat bearded slob!
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hello Michael,
> The foreign key constraint on T_OEPNV_HST_LIN.HST_NR
> references the wrong field in T_OEPNV_HST. Since you didn't
> specify a field, it's referencing the primary key HST_ID
> instead of HST_NR.
OK. Now I know what's wrong. I thought (for some reason) that if the
columns have
Hello everyone;
My systems admin says that he needs to have use of the Postgres user
without a password. His Debian package manager requires this.
He tells me that he can lock down that user on the system so that there
are no security concerns.
Can someone tell me if this is acceptable?
Greetings,
Here is a simple question:
Is it ok to put a unique index on the oid for my tables? We are in the process
of moving from Progress Software to PostgreSQL. In the Progress world, you
can always uniquely, and quickly find a record by using their version of oid,
which is recid. I remem
Lionel Lauer
UPDATED HOME ADDRESS:
58 Gore Street
Fitzroy, Victoria Australia 3065
UPDATED HOME NUMBER: (03) 9419 0533
Same mobile number: (0419) 385 307
Photo: http://www.pbase.com/image/24049356
His bitch: http://www.pbase.com/image/21824086
E-mail: [EMAIL PROTECTED]
---
On Thu, Nov 11, 2004 at 01:23:08 -0700,
Net Virtual Mailing Lists <[EMAIL PROTECTED]> wrote:
> Hi Kevin,
>
> I'm probably a bit more concerned about this than you are... I don't
> want to have to post anonymously just to protect my email address...
The lists are already publically archived and
I know I've seen this message before but I'm not quite sure what it
means. I think it's because I have two vacuums running over each
other. Does this sound right? It's comming from 7.4.x server.
ERROR: tuple concurrently updated
---(end of broadcast)---
Hi,
Just spotted it on LinuxToday. I don't think there would be many 8-way
configurations for opterons out there..
http://www.linuxelectrons.com/article.php/20041109100626264
Shridhar
---(end of broadcast)---
TIP 9: the planner will ignore your
Hi guys,
I am in troubles with a SERIAL field.
I have five tables. A parent table and four child
tables. When I do the INSERT in the parent table, I
have an ID (generated) by the sequence (SERIAL field),
and I have to use this ID to reference all child
tables.
Well, once I do an INSERT in the pa
At 03:23 AM 11/11/2004, Net Virtual Mailing Lists wrote:
Hi Kevin,
I'm probably a bit more concerned about this than you are... I don't
want to have to post anonymously just to protect my email address...
That is precisely why I stopped using Usenet about 5 years ago - it just
got overwhelming...
=?iso-8859-1?Q?Bj=F6rn_Platzen?= <[EMAIL PROTECTED]> writes:
> CREATE TABLE "T_OEPNV_HST"
> (
> "HST_ID" serial,
> "HST_NR" varchar(10),
> ...
> CONSTRAINT "T_OEPNV_HST_pkey" PRIMARY KEY ("HST_ID"),
> CONSTRAINT "T_OEPNV_HST_unr" UNIQUE ("HST_NR"),
> ...
> CREATE TABLE "T_OEPNV_HST_LIN" (
>
We are starting to ramp-up testing of our application, and we started getting
these messages in our log file:
LOG: checkpoints are occurring too frequently (15 seconds apart)
HINT: Consider increasing the configuration parameter "checkpoint_segments".
LOG: recycled transaction log file "00
--- William Yu <[EMAIL PROTECTED]> wrote:
> > ??? As a longstanding reader of the pgsql-
> > mailinglists, (including via news.postgresql.org
> on
> > occasion), all I see is some outsiders trying to
> help
> > us "fix" a problem that does not exist. And yes,
> I
> > have read most of the messag
What is the relationship between the "-d" parameter to postmaster and the
various "log_*" directives in the postgresql.conf? Specifically, does a certain
-d level have to be specified before certain log_* directives take effect?
- DAP
-
[EMAIL PROTECTED] writes:
> Lionel Lauer
These are of course all forged. They're all coming from
mailout01.ims-firmen.de [213.174.32.96]. Here he's trying to harass Lionel,
one of the people on news.groups.
--
greg
---(end of broadcast)---
TIP
From: "Björn Platzen" <[EMAIL PROTECTED]>
> "HST_NR" varchar(10) references "T_OEPNV_HST" on update cascade,
try:
"HST_NR" varchar(10) references T_OEPNV_HST(HST_NR) on update cascade,
gnari
---(end of broadcast)---
TIP 6: Have you searched our
On Wed, 10 Nov 2004, Oleg Lebedev wrote:
>
> In order to find all FK declared on a table I query tg_trigger view. The
> query lists all FKs declared on the table as well as all the ones
> referencing the table. I noticed that FKs that are declared on the table
> have pgtype equal to 21, and FKs re
Hello,
I'm new to the list (since yesterday evening) and I'm wondering what
kind of jokes are spamming my mailbox!
I can't laugh at all ...
... maybe I just don't understand ...
However ...
Bye,
Bjoern.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Beh
I think the best way would be not to use a SERIAL field, but an INTEGER
field and a sequence:
CREATE SEQUENCE parent_seq;
CREATE TABLE parent(id INTEGER, descrip CHAR(50));
So when you want to insert on the parent table, you obtain the next
value from the sequence and then you insert in the pare
On Thu, 11 Nov 2004, Terry Lee Tucker wrote:
> Is it ok to put a unique index on the oid for my tables? We are in the process
> of moving from Progress Software to PostgreSQL. In the Progress world, you
> can always uniquely, and quickly find a record by using their version of oid,
> which is reci
On Thu, 2004-11-11 at 09:59 -0300, MaRCeLO PeReiRA wrote:
> Hi guys,
>
> I am in troubles with a SERIAL field.
>
> I have five tables. A parent table and four child
> tables. When I do the INSERT in the parent table, I
> have an ID (generated) by the sequence (SERIAL field),
> and I have to use t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
option 1) use a stored procedure to create the record. Within a transaction
the last value function will return the correct last value, not the one of a
concurrent insert.
option 2) if you know that this user uses the same connection for all his
qu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 11 November 2004 07:04 am, Terry Lee Tucker wrote:
> Greetings,
>
> Here is a simple question:
>
> Is it ok to put a unique index on the oid for my tables? We are in the
> process of moving from Progress Software to PostgreSQL. In the Progr
On Thu, Nov 11, 2004 at 09:59:16 -0300,
MaRCeLO PeReiRA <[EMAIL PROTECTED]> wrote:
>
> Well, once I do an INSERT in the parent table, how can
> I know (for sure) which number id was generated by the
> sequence?
Use currval.
---(end of broadcast)-
I have the following select:
select to_char((Log_Fortrykk.SistePlate::time -
OrdreNew.SistePlate::time)::interval,'HH24:MI') as diff from Log_Fortrykk
I need the output to be HH:MM, e.g. 00:09... But my prb is when this diff is less than 0,
it shows as 00:-9 and not -00:09
How can I fix this?
R
On Thu, Nov 11, 2004 at 10:31:28 -0500,
Bob Powell <[EMAIL PROTECTED]> wrote:
> Hello everyone;
>
> My systems admin says that he needs to have use of the Postgres user
> without a password. His Debian package manager requires this.
>
> He tells me that he can lock down that user on the syst
Hi,
We have an app which uses the latest version of perl DBI and DBD::Pg to
execute a query, using placeholders. It fails to cast the float I send
into a number and generates the following message
"DBD::Pg::st execute failed: ERROR: invalid input syntax for
integer: "2.63" at -e line 8."
Here i
On Thu, Nov 11, 2004 at 10:04:30 -0500,
Terry Lee Tucker <[EMAIL PROTECTED]> wrote:
> Greetings,
>
> Here is a simple question:
>
> Is it ok to put a unique index on the oid for my tables? We are in the
> process
Yes, but you may occasionally have insert failures if the oid wraps around
and
Terry Lee Tucker wrote:
Greetings,
Here is a simple question:
Is it ok to put a unique index on the oid for my tables? We are in the process
of moving from Progress Software to PostgreSQL. In the Progress world, you
can always uniquely, and quickly find a record by using their version of oid,
wh
MaRCeLO PeReiRA wrote:
How can I now (for sure) with value was generated by
the sequence to fill the field ID?
(There is lots of users using the software at the same
time, so I am not able to use the last_value()
function on the sequence.)
Yes you are nextval()/currval() are multi-user safe. They r
What does it mean when you drop a database and then recreate with the
same name and all the objects are still there. I want to wipe out the db
and put back from pg_restore. After I re-create the db, all the old
tables are back before I run pg_restore.
--
Robert
---(end o
David Parker wrote:
> What is the relationship between the "-d" parameter to postmaster and
> the various "log_*" directives in the postgresql.conf? Specifically,
> does a certain -d level have to be specified before certain log_*
> directives take effect?
The -d flag in postmaster and postgres co
On Thu, 11 Nov 2004 19:11:38 +0100 Björn Platzen <[EMAIL PROTECTED]> wrote:
> I'm new to the list (since yesterday evening) and I'm wondering what
> kind of jokes are spamming my mailbox!
> I can't laugh at all ...
> .. maybe I just don't understand ...
don't worry about it. the lists are being "k
Kevin Barnard <[EMAIL PROTECTED]> writes:
> I know I've seen this message before but I'm not quite sure what it
> means. I think it's because I have two vacuums running over each
> other. Does this sound right? It's comming from 7.4.x server.
> ERROR: tuple concurrently updated
Were they both
Hi all,
Mike Cox sent an email to the newsgroup news.groups last night saying he's
giving up the usenet effort because of resistance here. What a shame.
I can't handle all the emails of this list on my mailbox, and quite frankly
I am interested in reading 10% of the emails only. Someone said earl
"Bob Powell" <[EMAIL PROTECTED]> writes:
> My systems admin says that he needs to have use of the Postgres user
> without a password. His Debian package manager requires this.
> He tells me that he can lock down that user on the system so that there
> are no security concerns.
Why can't he pu
Robert Fitzpatrick <[EMAIL PROTECTED]> writes:
> What does it mean when you drop a database and then recreate with the
> same name and all the objects are still there. I want to wipe out the db
> and put back from pg_restore. After I re-create the db, all the old
> tables are back before I run pg_
Phil Endecott <[EMAIL PROTECTED]> writes:
> Thanks Tom. I will upgrade to 8.0 one day but not soon. In the
> meantime, is there a way to judge a suficient setting for
> max_locks_per_transaction so that a global ANALYZE will work? It
> doesn't seem to be one lock per table or anything as simp
Do I get more oids on a 64 bit machine? That is, is it also an unsigned
four-byte integer on a 64 bit machine?
--
Until later, Geoffrey
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nom
On Thu, 2004-11-11 at 14:03, Doug McNaught wrote:
> Robert Fitzpatrick <[EMAIL PROTECTED]> writes:
>
> > What does it mean when you drop a database and then recreate with the
> > same name and all the objects are still there. I want to wipe out the db
> > and put back from pg_restore. After I re-c
My company has a product in beta which uses Postgres 7.4.3. We expect
to have a code freeze for our 1.0 product in March 2005. I'd really
like to use Postgres 8.x in our 1.0 product. We're especially looking
forward to the background writer and tablespaces.
Is the 8.0 release date known?
Suppose
Fixed, this was a problem with weakly typed languages such as perl,
sometime it doesn't know what SQL_TYPE to send, so it sends
SQL_VARCHAR.
The solution is to use
bind_param(,,DBI::SQL_FLOAT);
Tom
---(end of broadcast)---
TIP 2: you can get off
Geoffrey <[EMAIL PROTECTED]> writes:
> Do I get more oids on a 64 bit machine?
No.
regards, tom lane
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Thu, 11 Nov 2004, Net Virtual Mailing Lists wrote:
Hi Kevin,
I'm probably a bit more concerned about this than you are... I don't
want to have to post anonymously just to protect my email address...
That is precisely why I stopped using Usenet about 5 years ago - it just
got overwhelming...
I h
On Thu, Nov 11, 2004 at 14:17:45 -0500,
Robert Fitzpatrick <[EMAIL PROTECTED]> wrote:
> On Thu, 2004-11-11 at 14:03, Doug McNaught wrote:
> > Robert Fitzpatrick <[EMAIL PROTECTED]> writes:
> >
> > > What does it mean when you drop a database and then recreate with the
> > > same name and all the
Its all depends on what features you would use in Postgres.
Iam no expert but if you use simple selects/inserts/transactions you
would definitely be ok..
You can probably start looking at differences between 8.0 and 7.4.3 and
then decide.
- Goutam
> -Original Message-
> From: [EMAIL P
On Thu, Nov 11, 2004 at 14:17:41 -0500,
[EMAIL PROTECTED] wrote:
> My company has a product in beta which uses Postgres 7.4.3. We expect
> to have a code freeze for our 1.0 product in March 2005. I'd really
> like to use Postgres 8.x in our 1.0 product. We're especially looking
> forward to the b
Tom Larard <[EMAIL PROTECTED]> writes:
Just for reference these two cases are interpreted in ways that may not be
intuitive for programmers. Most languages treat constants that look like 'foo'
as string constants and then have rules for how string constants get cast.
Postgres has string datatyp
Robert Fitzpatrick <[EMAIL PROTECTED]> writes:
> Yeah, I was just starting to realize that these objects that keep coming
> back are in the template1 as well.any reason why I shouldn't drop
> the template1 and re-create like any other?
You can do that but you'll have to do:
CREATE DATABAS
On Nov 11, 2004, at 1:56 PM, Max wrote:
I am starting to believe that the issue behind all this fuss is an
identity
problem: does postgresql want to play side-by-side with the big
database
players and have an official, legal and legitimate newsgroup, or does
it
want to stay in the closet ?
Max
Bruno Wolff III wrote:
On Thu, Nov 11, 2004 at 10:04:30 -0500, Terry Lee Tucker
<[EMAIL PROTECTED]> wrote:
Greetings,
Here is a simple question:
Is it ok to put a unique index on the oid for my tables? We are in
the process
Yes, but you may occasionally have insert failures if the oid wraps
around
On Thu, Nov 11, 2004 at 03:34:14PM -0500, Geoffrey wrote:
> So this prompts a question regarding the documentation. I'm assuming
> that I can address the wrap-around issue based on the following found
> under "Notes" section of the "Create Table" document:
>
> "Whenever an application makes use
Quoting Bruno Wolff III <[EMAIL PROTECTED]>:
> On Thu, Nov 11, 2004 at 14:17:41 -0500,
> [EMAIL PROTECTED] wrote:
> > ...
> > Suppose 8.0 is released in December or January. Is it a sane thing
> > to put 8.0 in a shipping product within the first two months of its
> > release? I know that 8.0 is
On Thu, Nov 11, 2004 at 15:34:14 -0500,
Geoffrey <[EMAIL PROTECTED]> wrote:
>
> "Whenever an application makes use of OIDs to identify specific rows of
> a table, it is recommended to create a unique constraint on the oid
> column of that table, to ensure that OIDs in the table will indeed
>
On Thu, 11 Nov 2004 15:26:21 -0500, Andrew Rawnsley
<[EMAIL PROTECTED]> wrote:
> Sorry, but I think that's about as silly a statement as I've read on
> this list. I have never seen
> any Oracle, DB2, or Sybase materials that claim 'We're big time - we
> have a legit comp. newsgroup' (that woul
Greg Stark <[EMAIL PROTECTED]> writes:
> Robert Fitzpatrick <[EMAIL PROTECTED]> writes:
>> Yeah, I was just starting to realize that these objects that keep coming
>> back are in the template1 as well.any reason why I shouldn't drop
>> the template1 and re-create like any other?
> You can do t
At 03:34 PM 11/11/04, Geoffrey wrote:
Bruno Wolff III wrote:
On Thu, Nov 11, 2004 at 10:04:30 -0500, Terry Lee Tucker
<[EMAIL PROTECTED]> wrote:
Greetings,
Here is a simple question:
Is it ok to put a unique index on the oid for my tables? We are in
the process
Yes, but you may occasionally have in
You could switch to Beta 8 right now and start your testing. We've been
using it since the first beta came out, and it's been rock solid for us.
Mind you, we are limiting our use to simple selects/updates/inserts.
---(end of broadcast)---
TIP
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Andrew Rawnsley
> Sent: Thursday, November 11, 2004 12:26 PM
> To: Pgsql General
> Subject: Re: [GENERAL] comp.database.postgresql.*
>
>
>
> On Nov 11, 2004, at 1:56 PM, Max wrote:
>
> >
> > I am starting
>
> > Honestly, people here generally don't give a hoot what the other 'big'
> > databases do (which is
>
> I tend to look at it from complete different angle. Let's leave the
> group stuff for a while and think about SQL. PostgreSQL seeks
> to conform SQL standards as much as it is reasonable.
This morning I got bitten by the "SELECT INTO" / "CREATE TABLE AS"
from tables without OIDs bug in 7.4.1.
Postmaster killed all the backends and restarted - pg was down for 2
seconds.
This happened two times within a few minute period.
Now I am getting 'invalid page header in block 52979 of re
Steve Crawford <[EMAIL PROTECTED]> writes:
> This morning I got bitten by the "SELECT INTO" / "CREATE TABLE AS"
> from tables without OIDs bug in 7.4.1.
On a production server, you really ought to track bug-fix releases a
bit more enthusiastically than that :-(. However, I don't see anything
in
On Thu, 11 Nov 2004 13:56:48 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
>
> Were they both VACUUM ANALYZEs? There's a known gotcha that if you
> ANALYZE the same table concurrently in two different sessions, one
> of them can fail this way when it goes to update the pg_statistic
> entries. (Harm
Many thanks to all who have responded. I hope to be as helpful to the list
someday as each of you have been. Thanks...
On Thursday 11 November 2004 10:04 am, Terry Lee Tucker saith:
> Greetings,
>
> Here is a simple question:
>
> Is it ok to put a unique index on the oid for my tables? We are in
On Thursday 11 November 2004 3:14 pm, Tom Lane wrote:
> Steve Crawford <[EMAIL PROTECTED]> writes:
> > This morning I got bitten by the "SELECT INTO" / "CREATE TABLE
> > AS" from tables without OIDs bug in 7.4.1.
>
> On a production server, you really ought to track bug-fix releases
> a bit more en
Steve Crawford <[EMAIL PROTECTED]> writes:
>> Could you get a hex dump of that page?
> What is the best method to do this?
There's always "od -x" ... however, if you prefer you can use
pg_filedump from http://sources.redhat.com/rhdb/.
> Also, can I safely drop that table
Not unless you want to
Thomas Hallgren <[EMAIL PROTECTED]> writes:
> Not that I'm in an extreme hurry, just curious. Are we using different
> CVS repositories with some latency in replication or something?
The anon-CVS repository syncs to the master once an hour, last I heard.
regards, tom lane
I have a project "wyatterp.com" that was built to be an ERP development
library using postgresql as a backend. We use it internally to run a
120 employee manufacturing company. And it does everything from payroll
to production management.
I haven't been able to do much on it for a while but n
Still too new to SQL to have run across this yet ...
How does one return the latest row from a table, given multiple entries
of varying data?
i.e.: given a table that looks like this:
color | date
+
red| 2004-01-19
blue | 2004-05-24
red| 2004-04-12
blue | 2004
Scott,
On Nov 12, 2004, at 10:00 AM, Scott Frankel wrote:
color | date
+
red| 2004-01-19
blue | 2004-05-24
red| 2004-04-12
blue | 2004-05-24
How do I select the most recent entry for 'red'?
SELECT color, MAX(date)
FROM giventable
WHERE color = 'red' -- omit this
On Thu, 2004-11-11 at 14:34 -0500, Tom Lane wrote:
> Geoffrey <[EMAIL PROTECTED]> writes:
> > Do I get more oids on a 64 bit machine?
>
> No.
Nor will OIDs ever be 64 bit, I'd hazard to guess.
In any case using OIDs in applications is a bad idea -- you probably
should not be using them at all, l
A few more points --
> I'm probably a bit more concerned about this than you are... I don't
> want to have to post anonymously just to protect my email address...
> That is precisely why I stopped using Usenet about 5 years ago - it just
> got overwhelming...
Just out of curiousity, does your ma
> Mike Cox sent an email to the newsgroup news.groups last night saying he's
> giving up the usenet effort because of resistance here. What a shame.
Marc,
Should we leave this as is, or would you like someone to pick the RFD
back up?
(Yes, I'm saying I can volunteer. My pace would be a bit slow,
I interpreted the question slightly differently. I understood it to mean the
most recent instance of red which doesn't make much sense in this case but
let's say the table was
color | date | entered_by
+-+---
red | 2004-01-19| John
On Nov 11, 2004, at 5:09 PM, Michael Glaesemann wrote:
Scott,
On Nov 12, 2004, at 10:00 AM, Scott Frankel wrote:
color | date
+
red| 2004-01-19
blue | 2004-05-24
red| 2004-04-12
blue | 2004-05-24
How do I select the most recent entry for 'red'?
SELECT color, MAX(
On Fri, 12 Nov 2004, Joel wrote:
Mike Cox sent an email to the newsgroup news.groups last night saying he's
giving up the usenet effort because of resistance here. What a shame.
Marc,
Should we leave this as is, or would you like someone to pick the RFD
back up?
I'm not in the resistance group, but
On Thu, 11 Nov 2004, Scott Frankel wrote:
>
> On Nov 11, 2004, at 5:09 PM, Michael Glaesemann wrote:
>
> > Scott,
> >
> > On Nov 12, 2004, at 10:00 AM, Scott Frankel wrote:
> >
> >> color | date
> >> +
> >> red| 2004-01-19
> >> blue | 2004-05-24
> >> red| 2004-04-
On Thu, Nov 11, 2004 at 05:00:46PM -0800, Scott Frankel wrote:
> How does one return the latest row from a table, given multiple entries
> of varying data?
> i.e.: given a table that looks like this:
>
> color | date
> +
> red| 2004-01-19
> blue | 2004-05-24
> red
ORDER BY DESC LIMIT 1 is much simpler and more readable than a
sub-query.
Though the sub-query approach looks to be a good template for ensuring
more
accurate results by being more explicit.
Thanks to all who responded!
Scott
SELECT * FROM colortable WHERE color = 'red' ORDER BY date DESC LIMIT
The world rejoiced as [EMAIL PROTECTED] wrote:
> Quoting Bruno Wolff III <[EMAIL PROTECTED]>:
>
>> On Thu, Nov 11, 2004 at 14:17:41 -0500,
>> [EMAIL PROTECTED] wrote:
>> > ...
>> > Suppose 8.0 is released in December or January. Is it a sane thing
>> > to put 8.0 in a shipping product within the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 11 November 2004 10:23 am, Franco Bruno Borghesi wrote:
> I think the best way would be not to use a SERIAL field, but an INTEGER
> field and a sequence:
a "serial" is just a convenient shortcut to an int with an automatically
created seq
Christopher Browne <[EMAIL PROTECTED]> writes:
> The world rejoiced as [EMAIL PROTECTED] wrote:
>> Suppose 8.0 is released in December or January. Is it a sane thing
>> to put 8.0 in a shipping product within the first two months of its
>> release?
>> ...
>> Suppose I don't use any new features. Th
89 matches
Mail list logo
