Re: [SQL] performance difference in count(1) vs. count(*)?

Markus Bertheau <[EMAIL PROTECTED]> writes: > is there a difference performance-wise between select count(1) and > select count(*)? Nope. In fact, the latter is converted to the former during parsing. regards, tom lane ---(end of broadcast)--

[SQL] Abbr. for TIMESTAMP WITHOUT TIME ZONE?

Folks, Is there a postgresql-accepted abbreviation for TIMESTAMP WITHOUT TIME ZONE? I'm using that data type a lot, and it's getting kinda tedious to key in. I know that TIMESTAMP WITH TIME ZONE can be abbreviated "timestamptz". Surely there's an equivalent for WITHOUT? -- -Josh Berkus Ag

Re: [SQL] Problem with my query whithout double-quotes

Stephan Szabo wrote: > On Wed, 24 Jul 2002, ROUWEZ Stephane wrote: > > >>Hi, >>My pgsql runs on WinNT Server 4. When I try to >>SELECT nom, prenom FROM individu WHERE numero=2 >>I have : ERROR: Relation "individu" does not exist >>It only works if I write : >>SELECT "Individu"."Nom","Individu".

Re: [SQL] Abbr. for TIMESTAMP WITHOUT TIME ZONE?

Josh Berkus <[EMAIL PROTECTED]> writes: > I know that TIMESTAMP WITH TIME ZONE can be abbreviated "timestamptz". > Surely there's an equivalent for WITHOUT? As of 7.3, "timestamp" will be that abbreviation. We're currently in an interregnum as we move towards SQL-compliant interpretations of the

[SQL] performance difference in count(1) vs. count(*)?

Hello, is there a difference performance-wise between select count(1) and select count(*)? -- Markus Bertheau. Berlin, Berlin. Germany. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]