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
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
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
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
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
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
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
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
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
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,
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
---+-
À: 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
> 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?
>
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_
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
15 matches
Mail list logo