> This is an approach I also considered, but hoped for a solution without the
> expense (albeit small) of having to create a function.
How about this query?
CREATE TABLE transactions (
item_code text,
_date date,
qty double precision
)
;
INSERT INTO transaction
David Johnston wrote
> Basic idea: use ORDER BY in the window to auto-define a range-preceding
> frame. Create an array of all dates (tags in the example) that match with
> positive amounts. Negative amounts get their matching tag added to the
> array as NULL. The provided function looks into th
gmb wrote
> item_code | _date| qty | max
> -
> ABC | 2013-04-05 | 10.00| 2013-04-05
> ABC | 2013-04-06 | 10.00| 2013-04-06
> ABC | 2013-04-06 | -2.00| 2013-04-06
COPY D_2147483927_2147484848_TAB
(
CP
, CPR
, CHOUSENO
, CSTREET
, CLOCALITY
, CCITY
, CPROVINCE
, CCOUNTRY
, CZIP
)
FROM 'one.txt'
WITH DELIMITER ',' QUOTE '"' csv HEADER;
On Mon, Jan 17, 2011 at 7:59 AM, Amar Dhol
On 01/17/2011 05:59 AM, Amar Dhole wrote:
I have table created as follows
CREATE TABLE D_2147483927_2147484848_TAB(
CP VARCHAR(256) ,
CPR VARCHAR(256) ,
CHOUSENO VARCHAR(256) ,
CSTREET VARCHAR(256) ,
CLOCALITY VARCHAR(256) ,
CCITY VARCHAR(256) ,
CPROVINCE VARCHAR(256) ,
CCOUNTRY VARCHAR(
I have table created as follows
CREATE TABLE D_2147483927_2147484848_TAB(
CP VARCHAR(256) ,
CPR VARCHAR(256) ,
CHOUSENO VARCHAR(256) ,
CSTREET VARCHAR(256) ,
CLOCALITY VARCHAR(256) ,
CCITY VARCHAR(256) ,
CPROVINCE VARCHAR(256) ,
CCOUNTRY VARCHAR(256) ,
CZIP VARCHAR(256) ,
CCO VAR
NosyMan wrote:
Hi everyone,
I have some kind of strange problem. I want to build general parametrized
trigger for my database. The parameter sent to the trigger contains a column
name that trigger should be check.
The 'vt' variable contains the column name. In the above statement I want th
Hi everyone,
I have some kind of strange problem. I want to build general parametrized
trigger for my database. The parameter sent to the trigger contains a column
name that trigger should be check.
CREATE OR REPLACE FUNCTION F_T_IU__check() RETURNS trigger AS $$
DECLARE
Dear
postgresql,
I am just starting to learn
SQL.
I have attached a script that
allows me to create some tables and indexes. I have rows that are inserted into
the tables.
I need some help with creating multiple subqueries and table joins, (six or seven table joins).
Can
you help?
Paul Mo
Justin Clift <[EMAIL PROTECTED]> writes:
> I'm getting this error, which to me makes no sense. Running PostgreSQL
> 7.0.3 on Mandrake 7.2 (compiled from source, not the rpms).
> ERROR: record arow has no field description
Hm. If you don't have any references to "arow.description" then this
se
Hi all,
I'm getting this error, which to me makes no sense. Running PostgreSQL
7.0.3 on Mandrake 7.2 (compiled from source, not the rpms).
The code is in a pl/pgsql function I am writing and I can't see why it's
complaining.
This is the appropriate part of the code :
arow
11 matches
Mail list logo
