Hi people,
I'm writing a plpgsql function in pgadminIII and want to know if the arguments
can have the following type:
tablename.columnname%TYPE
If so, how do I accomplish this in pgadminIII as it doesn't allow me to change
the arguments to this type.
The function I'm writing looks like this:
Dear postgresql experts,
I want to know if postgresql has facilities for getting the first and or the
last in a by group.
Suppose I have the following table:
resnr,dep,arr,cls,dbd meaning reservationsnumber, departure station, arrival
station, the class of the reservation and the daysbeforedep
From:
"Thomas Kellerer"
To:
"" Dino Vliet wrote on 16.05.2010 18:07:
> Dear postgresql experts,
>
> I want to know
if postgresql has facilities for getting the first and or
> the
last in a by group.
>
> Suppose I have the following table:
>
> resn
Dear postgresql list,
I have some troubles generating data
for a analysis task at hand.
I have a table (table A) containing 5
million records and 28 number of attributes. This table is 461MB big
if I copy it to a csv file.
I want to create another table (table
B) based o
Dear postgresql people,
Introduction
Today I've been given the task to proceed with my plan to use postgresql and
other open source techniques to demonstrate to the management of my department
the usefullness and the "cost savings" potential that lies ahead. You can guess
how excited I am r
Hi postgresql list,
If I have two tables with the same number of rows but different columns and I
want to create one table out of them what would be the way to do that in
postgresql?
Table A has N number of rows and columns X,Y,Z and Table B has N number of rows
and P,Q,R as columns. None of
--- On Sat, 4/3/10, Raymond O'Donnell wrote:
From: Raymond O'Donnell
Subject: Re: [GENERAL] join two tables without a key
To: "Dino Vliet"
Cc: pgsql-general@postgresql.org
Date: Saturday, April 3, 2010, 1:01 PM
On 03/04/2010 11:16, Dino Vliet wrote:
> Hi postgresql lis
My sysadmin has changed the values for shmall to 256MB
(268435456) and shmmax to 1GB (1073741824) and I
wonder if these values seem ok to you. We are working
on a linux system (2.4 kernel) and have 2 GB RAM at
our disposal. I have this large database running (15
million records).
Are there any oth
sider changing in order
to boost performance.
I'm using postgresql 7.4.
Brgds
Dino
--- Dino Vliet <[EMAIL PROTECTED]> wrote:
> My sysadmin has changed the values for shmall to
> 256MB
> (268435456) and shmmax to 1GB (1073741824) and I
> wonder if these values seem ok to you. W
Hi folks,
Maybe a little bit off topic, but I want to convince
my managers of the value of opensource products and
decided that I will reverse engineer the datawarehouse
at my company. We are a small player and our
datawarehouse solution is based on an ETL tool from
Informatica, Oracle and Busines
Hi folks,
when I start pgadmin3 on my system I get the following error:
/libexec/ld-elf.so.1: Shared object "libpq.so.4" not found, required by
"pgadmin3"
The only thing I have done lately is upgrade the database to 8.2 in the freebsd
ports system. Pgadmin did work in the past, so what could
I have the following config but increasing the shared buffers to a value
greater then 32 doesn't let the database server start (I want a value of 256MB
there because I will have a giant table of 12 million rows which will be
qeuried extremely).
I have a 3GB RAM amd64 system running freebsd 6.1
and if so, when will this be
fixed?
Brgds
Dino Vliet
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)---
TIP 9: the planner will ignore your desire to
Hi guys,
I trying for days to get this simple plpgsql procedure
to run but I keep getting this error:
psql:pgsql_procedure.txt:15: ERROR: syntax error at
or near at character 17
QUERY: copy cancel TO $1 with delimiter as ',' null
as '.'
CONTEXT: SQL statement in PL/PgSQL function doedit
near
Nope:-(
I added it just now and still the same error message!!
--- Bricklen Anderson <[EMAIL PROTECTED]> wrote:
> Dino Vliet wrote:
> > Hi guys,
> >
> > I trying for days to get this simple plpgsql
> procedure
> > to run but I keep getting this error:
Ok thanks for now. I understood the problem and what I
should do to fix it. Will try that later.
Thanks for all the tips and the REALLY FAST answers!!
--- John DeSoi <[EMAIL PROTECTED]> wrote:
>
> On Mar 27, 2006, at 2:10 PM, Dino Vliet wrote:
>
> > Can somebody te
Hi,
In my pl/pgsql procedure I have the following line:
execute 'copy cancella to ' || location || ' with
delimiter as \',\'';
Location is a string that gives the absolute pathname.
It's obvious what I'm aiming for, but this still gives
an error because of the two '' I'm missing around the
loca
Solved:-)
Thanks for your aanswer, now I can go further with
exploring pl/pgsql. Looks nice.
Brgds
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Dino Vliet <[EMAIL PROTECTED]> writes:
> > In my pl/pgsql procedure I have the following
> line:
>
> > execute 'co
Hi folks,
I'm busy with analyzing some data and therefore will
have to store 2 big tables containing 50 million obs &
25 million obs. Selecting some interesting obs can
decrease these tables with maybe a factor 10 but
eventually I will have to combine them using a join.
These tables contain almost
Hi folks,
I'm new to PostgreSQL and am busy tring to work with
it. Of pl/pgsql I know even less and that's the part I
have a question on right now. I have this nice example
to get me started with
pl/pgsql...
I have a table with the schedule of a service my sport
team wants to offer:
Table Sch
Dear all,
I have this problem with getting information out of my
database and I don't know if it is my knowledge of sql
or that this is something that can't be done in sql.
I have the following table:
id fdateprod pricestat nr_items sdate
x1 23-11-2003123 456 yes 7
Maybe I've missed it but can someone plese help me
with this?
Brgds and thanks in advance,
--- Dino Vliet <[EMAIL PROTECTED]> wrote:
> Hi folks,
> I'm new to PostgreSQL and am busy tring to work with
> it. Of pl/pgsql I know even less and that's the part
> I
alles() RETURNS trigger AS '
BEGIN
FOR i in 0..7 LOOP
INSERT INTO lessons (..)
SELECT dayofweek,startdate + (i*7), enddate +
(i*7),...;
RETURN NEW;
END LOOP;
END;
' LANGUAGE plpgsql;
--- Richard Huxton <[EMAIL PROTECTED]> wrote:
> Dino Vliet wrote:
> > I'm gett
23 matches
Mail list logo