What I'd like to do is use dblink to extract a few rows from a remote
database and manipulate these within a function in pl/pgsql. Something
like this:
CREATE OR REPLACE FUNCTION find() RETURNS INTEGER AS '
DECLARE
count INTEGER:
myrec RECORD;
BEGIN
FOR myrec IN SELECT * FROM DBLINK
Hi there,
I was in troubles with a UPDATE+IN statement:
The following command use to take about 5 minutes to
be done:
UPDATE requisicao SET conclusao='3' WHERE reg IN
(SELECT reg FROM requisicao WHERE now()-data>'15
days');
The table 'requisicao' has only about 400 lines (!!).
If I change it t
On Monday 03 November 2003 06:46, Shridhar Daithankar wrote:
> Hi all,
>
> I hope this is useful for people using open office regularly. Can we get
> this posted on techdocs?
There's also an (experimental) direct access driver available from the URL
below. Saves all the messing with ODBC
http:/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Shridhar Daithankar wrote:
> Hi all,
>
> I hope this is useful for people using open office regularly. Can we get
> this posted on techdocs?
>
> Regards
> Shridhar
>
> Original Message
> -BEGIN PGP SIGNED MESSAGE-
> Hash: S
On 03/11/2003 06:46 Shridhar Daithankar wrote:
Hi all,
I hope this is useful for people using open office regularly. Can we get
this posted on techdocs?
[snip]
There's also an OpenOffice driver for PG
(http://dba.openoffice.org/drivers/postgresql/index.html). Its still alpha
quality but it wor
On 01/11/2003 01:36 Ryan Mack wrote:
First, I want to confirm my understanding that the "without fee" clause
in
the PostgreSQL license means that a party may not sell PostgreSQL or
works
derived from the PostgreSQL source code.
Second, do loadable PostgreSQL modules constitute a derived work? Can
CY wrote:
I wanted a auto-increasement function, similar to sequence, to increase
a field. I cannot use CREATE SEQUENCE because it cd_line_no will start
again with a new coursedetail.
CREATE TABLE coursedetail
(
cd_cf_id char(30),
cd_line_no smallint default auto_increment b
