Hi,
I hope the following link will help you.
http://www.postgresql.org/docs/8.0/static/plpgsql-expressions.htmlOn 12/5/05,
Byrne Kevin-kbyrne01 <[EMAIL PROTECTED]> wrote:
Has
anyone seen any strange behaviour as regards the now() function when
accessing a db via odbc layer. The behaviour I have
DELECT FROM table
WHERE (ProdID,ChangeDate) not in
(SELECT ProdID,MAX(ChangeDate) FROM table
GROUP BY ProdID)
I hope this works.
On 12/7/05, Alex <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a table where I store changes made to an order. The looks like
> ProdID, ChangeDate, Change1, Change2, ...
Hi,
you need to increase maintenance_work_mem in postgresql.conf file.
http://www.powerpostgresql.com/Downloads/annotated_conf_80.html
Regards
Pandu
On 12/12/05, DANTE ALEXANDRA <[EMAIL PROTECTED]> wrote:
> Hello,
>
> This is my first posting in this mailing list and I am a PostGreSQL newbie.
>
UPDATE
geom_summen a
SET
a.var228= a.var228 + (SELECT b.var228 FROM geom_ns_wrf b
WHERE b.gid=a.gid);
Use Coalesce if you want to substitute zero for null, otherwise the
column will be updated to null, if any of the values that was summed
was null.
On 12/1
This link explains lot of useful techniques for backup and restore
http://www.postgresql.org/docs/8.1/static/backup.html
On 12/15/05, Marc Brünink <[EMAIL PROTECTED]> wrote:
> Hi list,
>
> I know this was asked a lot of times on this mailing list. But actually
> no reply satisfied me :-)
> Howeve
Hi,
Refer http://www.postgresql.org/docs/8.1/static/functions-sequence.html
On 12/23/05, Assad Jarrahian <[EMAIL PROTECTED]> wrote:
> Hi all,
>So I started to make some changes with my code here and there
> (nothing to do with the relevant lines) and suddenly currval and
> rollback don't work
Assuming records is the name of a table...
create or replace function getrecord(int,text) RETURNS SETOF records as $$
DECLARE
row records%rowtype;
BEGIN
FOR row IN SELECT * FROM my_tbl
WHERE ...
LOOP
RETURN NEXT row;
END LOOP;
RETURN;
END;
$$ LANGUAGE plpgsql;
On 1/5/06, Matthew Peter <[EMAIL
To get rid of ^M characters you could use
cat file | tr -d ^M
you need to type ^V before you type ^M in the preceeding command. But
^V will not be displayed on the screen.
You might need to change directory permission too.
use chmod +rx .
For this command to succeed you need to execute this co
; > C1
> > E1
> > B2
> > C2
> > E2
> > .
> > .
> > .
> >
> >
> >
> > Any more suggestions on how to solve this? :(
> >
> >
> >
> >
> >
> > On 1/6/06, Pandurangan R S <[EMAIL P
2
> > E2
> > .
> > .
> > .
> >
> >
> >
> > Any more suggestions on how to solve this? :(
> >
> >
> >
> >
> >
> > On 1/6/06, Pandurangan R S <[EMAIL PROTECTED]> wrote:
> > > To get rid of ^M characters you co
; entry(entry_id) ON UPDATE RESTRICT ON DELETE RESTRICT
> "distance_subject_id_fkey" FOREIGN KEY (subject_id) REFERENCES
> entry(entry_id) ON UPDATE RESTRICT ON DELETE RESTRICT
>
>
>
> On 1/6/06, Pandurangan R S <[EMAIL PROTECTED]> wrote:
> > Please
I hope this error arises when you do a insert.
Can u post your insert statement that caused this error?
On 1/20/06, DB Subscriptions <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have this table:
>
> CREATE TABLE users
> (
> userid varchar(100) NOT NULL,
> nama varchar(50) NOT NULL,
> pword varchar
Hi,
SELECT object_id
FROM image
GROUP BY object_id
NOT HAVING sort_order = 1;
After changing the "NOT HAVING" to "HAVING" the error message was
"column "sort_order" must appear in the GROUP BY clause or be used in
an aggregate function"
The postgres document says "SELECT list and HAVING clau
http://archives.postgresql.org/pgsql-general/2006-01/msg01259.php
On 1/27/06, Emil Rachovsky <[EMAIL PROTECTED]> wrote:
>
> Hi,
> I am using PostgreSQL 8.1.0 . How can I find a temp
> table from my session, having the name of the table?
> Can anyone show me what query should I execute? I've
> tri
Hi,
Is there any way to change a SERIAL type to an INTEGER? I think that it
should be easy, since SERIAL is, in fact, an INTEGER with some conditions.
There serial column is just a integer, with default as nextval from a
sequence, so there is no neccessity to change the datatype of the
column. Yo
select f1,f2,f3,f4 from table1 EXCEPT ALL select f1,f2,f3,f4 from table2
http://www.postgresql.org/docs/8.1/static/sql-select.html
On 1/27/06, Stefano B. <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I have two identical tables
>
> table1 (f1,f2,f3,f4 primary key (f1,f2,f3,f4))
>
> table2 (g1,g2,g3,g4 p
You may be able to recover them, but you could make things worser if
you do not do it correctly.
http://archives.postgresql.org/pgsql-patches/2005-02/msg00126.php
http://archives.postgresql.org/pgsql-general/2006-02/msg00091.php
On 2/6/06, surabhi.ahuja <[EMAIL PROTECTED]> wrote:
> hi,
>
> i ha
Did you check if your pg_restore was successful?
I think you need to include the following option while using pg_dump &
pg_restore
-C, --create include/issue commands to create database
On 2/6/06, surabhi.ahuja <[EMAIL PROTECTED]> wrote:
> i am trying to do :
>
> pg_dump -f op.tar
You need to use two single quotes around ^ (like ''^'') or use the
dollar quoting approach.
http://www.postgresql.org/docs/8.1/static/plpgsql-development-tips.html
On 2/10/06, surabhi.ahuja <[EMAIL PROTECTED]> wrote:
>
>
> but how should i do it within a stored procedure
> something like:
>
> C
try using CACHE 1 (which is default) in the sequence defintion.
http://www.postgresql.org/docs/8.1/static/sql-createsequence.html
On 2/10/06, Jean-Christophe Roux <[EMAIL PROTECTED]> wrote:
> Hello,
> I have a table with and id field (primary key) which default value is the
> result of a sequence
20 matches
Mail list logo
