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)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[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 Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
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"."Prenom" FROM "Individu" WHERE >>"Individu"."NumIndiv"=2 >>Can someone help me ? >> > > It looks like you created the table with double quotes around the > names at which point you should always use double quotes to refer > to it (yes, if the name was "foo" you *can* refer to it as foo, but > you really shouldn't). Your table names are case sensitive. PostgreSQL will make them all lowercase by default, unless you quote them. -- Keith Gray Technical Services Manager Heart Consulting Services P/L mailto:[EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
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 these type names ... regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[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]
