[GENERAL] problem with select

2010-11-04 Thread Adrian Johnson
Dear group: I have a table structure like following: city: city_blockage_from age_to name SF 10 20grade1 SF 21 30grade1 SF 35 40grade1 SF 53 19grade2 SF 100 153 grade2 NY

Re: [GENERAL] Problem with SELECT

2007-10-08 Thread A. Kretschmer
am Mon, dem 08.10.2007, um 3:28:04 -0700 mailte marwis1978 folgendes: > I have a following table > -+ > day | quantity > -+ > > where day is a date and quantity is an integer value. Now I need to > make a SELECT statement on this table which returns me a full > informati

[GENERAL] Problem with SELECT

2007-10-08 Thread marwis1978
I have a following table -+ day | quantity -+ where day is a date and quantity is an integer value. Now I need to make a SELECT statement on this table which returns me a full information on a whole month, it means day>='2007-10-01' and day <'2007-11-01' but if there is no

Re: [GENERAL] Problem with select statement

2005-02-21 Thread phil campaigne
Ragnar Hafstað wrote: On Sun, 2005-02-20 at 20:01 -0500, phil campaigne wrote: Hi gnari, I forgot one thing. I also need to restrict the selecct with two more qualifiers where contest_id =1 and team='Duke' I'm confused where to put it in the select statement. I tried this but it doesn't work

Re: [GENERAL] Problem with select statement

2005-02-20 Thread phil campaigne
Ragnar Hafstað wrote: On Sun, 2005-02-20 at 18:18 -0500, phil campaigne wrote: Yes Gnari it works now! all I had to do in addition to your advice was alias the sub select: hardwoodthunder=# select player_number,player_name,cum_score,sum(a),sum(c),sum(t) from ( select player_number, player_na

Re: [GENERAL] Problem with select statement

2005-02-20 Thread Ragnar Hafstað
On Sun, 2005-02-20 at 18:18 -0500, phil campaigne wrote: > Yes Gnari it works now! > all I had to do in addition to your advice was alias the sub select: > > hardwoodthunder=# select > player_number,player_name,cum_score,sum(a),sum(c),sum(t) from ( select > player_number, player_name, cum_scor

[GENERAL] Problem with select statement

2005-02-20 Thread phil campaigne
Yes Gnari it works now! all I had to do in addition to your advice was alias the sub select: hardwoodthunder=# select player_number,player_name,cum_score,sum(a),sum(c),sum(t) from ( select player_number, player_name, cum_score, (select player_points where aspect='A') as A ,(select player_points

Re: [GENERAL] Problem with Select output

2004-12-22 Thread Fernando Schapachnik
sleect function(ssd_a) from ... where function is one of the built-in text function or one of your own written in some of the supported (by your version) procedure languages. Regards. En un mensaje anterior, srini vasan escribió: > --- srini vasan <[EMAIL PROTECTED]> wrote: > > > Hi > >I a

Re: [GENERAL] Problem with Select output

2004-12-22 Thread Alvaro Herrera
On Wed, Dec 22, 2004 at 07:50:56AM -0800, srini vasan wrote: Hi, >Can anybody please help me in this? You could use the replace(text,text,text) function: alvherre=# create table foo (a text); CREATE TABLE alvherre=# insert into foo values ('hola alvherre'# '); INSERT 155224 1 alvherre=# sel

Re: [GENERAL] Problem with Select output

2004-12-22 Thread srini vasan
Hi all Can anybody please help me in this? Regards Srini --- srini vasan <[EMAIL PROTECTED]> wrote: > Hi >I am facing some issues with select query. The > values of the columns in one table contains "\n" as > a > part of the value. So when I execute the select > query > on this table,

[GENERAL] Problem with Select output

2004-12-22 Thread srini vasan
Hi I am facing some issues with select query. The values of the columns in one table contains "\n" as a part of the value. So when I execute the select query on this table, I am getting the following output. # select * from stdhlr_subscriber_profile ; subscriber_id | ssd_a ---+-

RE: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4

2000-01-28 Thread Nicolas Huillard
À: John Brothers Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Objet: Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 John Brothers <[EMAIL PROTECTED]> writes: > I don't think that patch will work - Hiroshi whipped up that patch for > me a week ago for a differen

Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4

2000-01-28 Thread Bruce Momjian
> Bruce Momjian <[EMAIL PROTECTED]> writes: > >> Hiroshi neglected to mention that you'd probably need to drop and > >> recreate the index after applying the patch; if it's indeed out of > >> order, just patching the comparator bug isn't enough to fix it. > > > Does Hiroshi's patch get applied? >

Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4

2000-01-28 Thread Bruce Momjian
Applied. [Charset iso-8859-1 unsupported, filtering to ASCII...] > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]]On Behalf Of Nicolas Huillard > > > > I have a DB with is updated using MS Access. Primary keys are > > Int4 with default random values ("Num_

[GENERAL] Problem with SELECT on large negative INT4

2000-01-27 Thread Nicolas Huillard
I have a DB with is updated using MS Access. Primary keys are Int4 with default random values ("NuméroAuto" + "Aléatoire" in Access). The DB is migrated as-is in Postgres, with tbl_prod.cle_prod field containing values from -2057496808 to 2139583719. When I SELECT in the table, using the INT4 cl