Re: [GENERAL] business perspective

* Peter Eisentraut <[EMAIL PROTECTED]> wrote: | | Ryan Mahoney writes: | | > Here are a few sites that I am basing my comparison on: | > sendmail.com | > sun.com | > redhat.com | > ibm.com | | I find none of these web sites particularly well-done from a usability | point of view. On the contrar

Re: [GENERAL] Query

> Hi ! > > I'm trying to execute the following query: > "SELECT TOP 10 * FROM table1" > > It gives me the error message > parser: parse error at or near "2" > > Can i use SELECT TOP ? > Is there any other way to execute the same query not using SELECT TOP ? > See the L

Re: [GENERAL] Query

> I'm trying to execute the following query: > "SELECT TOP 10 * FROM table1" SELECT * FROM table1 LIMIT 10 -- might give you what you're looking for.. I've not seen TOP, though I could guess where it comes from (Oracle?) -- top seems to imply order so you might want to ORDER BY some

Re: [GENERAL] locale and spanish acute

On Mié 12 Sep 2001 21:52, Peter Eisentraut wrote: > Martín Marqués writes: > > > > What does "accent-fold" mean? > > Convert all accented characters to some other characters in a way that is > meaningful to you. OK, I think I got what you told me. lets see... I have this query: select count(*) f

Re: [GENERAL] Inheritance c.cities ??

R Talbot wrote: > R Talbot wrote: > > > Looking at the Postgresql manual in the inheritance section I see > > abbreviations. > > > > i.e. > > SELECT c.name, c.altitude > > FROM cities* c > > WHERE c.altitude > 500; > > > > c.name of course refering to cities.name > > My question is where is the

Re: [GENERAL] where cannot use alias name of column?

On Thu, 13 Sep 2001, Giorgio Volpe wrote: > May be it's my ignorance about sql ... > but why cannot i use alias name of a column in a where clause? > > # select key as cc from mytable where cc > 0; > ERROR: Attribute 'cc' not found Because the select list (the key as cc part) isn't evaluated u

Re: [GENERAL] count of occurences PLUS optimisation

HACKERS: see the end of this message about a possible optimisation for ORDER BY+LIMIT cases (the normal use of LIMIT?) Adam wrote: > > I help run a job database and have a table of search records. I want > a query that will return the top 10 jobs by search frequency. I'm > familiar with ORDER

Re: [GENERAL] where cannot use alias name of column?

En un mensaje anterior, Giorgio Volpe escribió: > May be it's my ignorance about sql ... > but why cannot i use alias name of a column in a where clause? > > > # select key as cc from mytable where cc > 0; > ERROR: Attribute 'cc' not found AFAIK you can't use alias in ther where part. Good lu

Re: [GENERAL] Inheritance c.cities ??

R Talbot wrote: > > Looking at the Postgresql manual in the inheritance section I see > abbreviations. > > i.e. > SELECT c.name, c.altitude > FROM cities* c > WHERE c.altitude > 500; > > c.name of course refering to cities.name > My question is where is there an alias reference of c AS citie

[GENERAL] where cannot use alias name of column?

May be it's my ignorance about sql ... but why cannot i use alias name of a column in a where clause? # select key as cc from mytable where cc > 0; ERROR: Attribute 'cc' not found -- Giorgio - ---(end of broadcast)-

[GENERAL] General database programming question

Hi to all! I want to ask a general database programming question. Here it is... In a programming language that handles exceptions, where I have to put the db.commit/db.rollback statement? These are some solutions... //db is a generic database connection object /* SOLUTION 1 */ db.begin

Re: [GENERAL] compiling ...

mike wrote: > > "cc -O -o pgsample pgsample.c -L/usr/local/pgsql/lib -lpq" went thru. You have to put the marked part into the rule for the linker. With kind regards / Mit freundlichem Gruß Holger Klawitter -- Holger Klawitter [EM