Hi,
I am a newbie to SQL and postgresql too.
please guide me in the following...
1.How i can create date while i am inserting into the table ,in which the
field is date data type.(date should not be a current date and its should be
created
as in java date(int,int,int)
2. How i can compare th
On Mon, Mar 26, 2001 at 09:53:52AM +0200, Poul L. Christiansen allegedly wrote:
> Log into PostgreSQL using psql and run the help command:
> "\h create trigger".
>
> See also:
> http://www.postgresql.org/users-lounge/docs/6.5/postgres/sql-createtrigger.htm
>
> HTH,
> Poul L. Christiansen
>
> On
On Mon, Mar 26, 2001 at 12:24:07PM +0400, waheed_rahuman wrote:
>
>
> Hi,
>
> I am a newbie to SQL and postgresql too.
> please guide me in the following...
Any problem with documentation?
> 1.How i can create date while i am inserting into the table ,in which the
> field is date data type.(
Hello there!
here is what i want to realize:
a trigger, that puts a now() in the last_updated field, on any update of
that table.
i read the manual but i wasnt able to make a working function.
what is the return value here? is there any or is it void?
has somebody a example for me that is simi
Hello there
I have still the same problem. Any help would really be appreciated !
Thanks ... jr
Is it possible (and I think it is) to do the following :
I have a table with diameters and types. I need to build a comma separated
string.
typ diam
01800
01840
01870
0
From: <[EMAIL PROTECTED]>
> I have a table with diameters and types. I need to build a comma separated
> string.
>
> typ diam
> 01800
[snip]
>
> select diam from zylinder where typ='01'
>
> should produce the string "800,840,870,1120"
Try the following as a starting point:
CREATE
From: "Norbert Schollum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 10:24 AM
Subject: [SQL] Functions and Triggers
> Hello there!
>
> here is what i want to realize:
>
> a trigger, that puts a now() in the last_updated field, on any update of
> that table.
>
> i rea
Hi,
Thanks for your valuable information. I tried the
cron. i typed
cron -e
and entereed into the input area. but i don't know how
to save the cron file. I pressed ctrl+z and came out
from cron. but i edit the cron file i found nothing on
it.(i.e using pico filename.) Please tell me some
de
The following function will convert a given list into a comma delimited
string (the argument should be the typ):
CREATE FUNCTION dima_list(int4) RETURNS text AS '
DECLARE
recrecord;
list text;
BEGIN
list :=
Hi all,
I have written a trigger to update a table called categories whenever
a tuple is either deleted or inserted in tables articles, media, and links.
It works fine for inserts but "pukes" on deletes :). I am using two auxiliary
addcount(varchar) and delecount (varchar)
I am getting the follow
CREATE FUNCTION lastupdated() RETURNS opaque AS '
begin
new.last_updated := CURRENT_TIMESTAMP;
return new;
end;
' LANGUAGE 'plpgsql';
CREATE TRIGGER trigname BEFORE INSERT OR UPDATE on tblname
FOR EACH ROW EXECUTE PROCEDURE lastupdated();
Note: you could use now() instead of CURRENT_TIMES
> Thanks for your valuable information. I tried the
> cron. i typed
>cron -e
> and entereed into the input area. but i don't know how
> to save the cron file. I pressed ctrl+z and came out
> from cron. but i edit the cron file i found nothing on
> it.(i.e using pico filename.) Please tell me
Still learning this stuff, so please be gentle...
jeff=# select * from test_it;
typ | diam
-+--
01 | 800
01 | 840
01 | 870
01 | 1120
02 | 760
02 | 780
02 | 800
02 | 900
03 | 1200
03 | 1234
03 | 1352
(11 rows)
jeff=# \! cat test_it
drop function test_it_too(text);
> create function updateCat() returns opaque as '
> declare
> rec record;
> rename new to cat;
> rename old to ct;
> maxlen integer;
>
> begin
> if tg_op = ''INSERT'' and cat.category is null then
> raise exception ''You are missing entry for category field'';
I have a simple script to automate sql statements: q " select * from
tablename" where q is an alias to echo "$@ ; " | psql imdb
Turning on security breaks this script since is need s password.
the new one works a before: q "select *..." passwd where q is now
an expect script:
#!/usr/bin/
A. Van Hook writes:
> #!/usr/bin/expect
>
> set query [lindex $argv 0]
> set query [lindex $argv 1]
>
> spawn psql imdb -U hook -n
> expect "Password: ";
> send "$passwd\n ";
> expect "imdb=# ";
> send "$query;\r";
> expect "imdb=# ";
>
Mathijs Brands writes:
> Has anybody ever tried calling Java code from a pgsql trigger written
> in C? Shouldn't this be possible using JNI?
I have, and given the current Java implementations it's a desaster.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
---
On Mon, Mar 26, 2001 at 07:00:43PM +0200, Peter Eisentraut allegedly wrote:
> Mathijs Brands writes:
>
> > Has anybody ever tried calling Java code from a pgsql trigger written
> > in C? Shouldn't this be possible using JNI?
>
> I have, and given the current Java implementations it's a desaster.
> Instead of "ctrl+z", press ":wq" (colon for command mode, w for write, q for
> quit).
If you are still mystified, "ctrl+z" stops a process running on a
terminal, so it's likely that your vi is still running idle. Type 'fg'
on the same terminal to bring it back. For more details on job
control,
Here is the senario...
I have a table defined as
create table details (
field1
field2
.
.
.
);
and a function:
create function get_details(int4) returns details as '
declare
ret details%ROWTYPE;
site_recrecord;
cntct contacts%ROWTYPE;
begin
select
Tom, Jan,
I've already contacted PGSQL Inc. support about this, but I thought
that you might have some immediate insight.
I'm using 7.1 Beta 3, which has been pretty stable up until now. This
morning, I went to export a function I spent 5 hours debugging on on
Friday to text so
Hi,
I am new to this list. I have browsed the list archives and tried a
search, but haven't found anything about my problem.
I am porting several applications to PostgreSQL and have come across a
number of instances where a string literal does not work without an
explicit cast to some character
> > Thanks for your valuable information. I tried the
> > cron. i typed
> >cron -e
> > and entereed into the input area. but i don't know how
> > to save the cron file. I pressed ctrl+z and came out
> > from cron. but i edit the cron file i found nothing on
> > it.(i.e using pico filename.)
On Mon, 26 Mar 2001, Stephan Szabo wrote:
>
> > create function updateCat() returns opaque as '
> > declare
> > rec record;
> > rename new to cat;
> > rename old to ct;
> > maxlen integer;
> >
> > begin
> > if tg_op = ''INSERT'' and cat.category is null then
> >
"Josh Berkus" <[EMAIL PROTECTED]> writes:
> I'm using 7.1 Beta 3, which has been pretty stable up until now. This
> morning, I went to export a function I spent 5 hours debugging on on
> Friday to text so that I could have a copy of the final version. To my
> horror, the function was GONE
Tom,
> Ick. Were you maybe working on it inside a transaction that you
> forgot
> to commit?
Nope. Friday was debugging work; the function had already been saved as
a buggy version. I can even find the last buggy call to the function,
on Friday, in the logs.
I do have a copy of the buggy ver
Hi,
I'm using serial fields to generate IDs for almost all object in my
database. I insert an empty row, get the CURRVAL() of the sequence
and then update to that value.
I had understood (and now, I can't find the reference to back this up)
that serial is implemented in such a way that race con
"Josh Berkus" <[EMAIL PROTECTED]> writes:
>> Should still be there in the table, if you haven't vacuumed. Getting
>> it out again is another story though. If it was a small enough
>> function,
>> good ol' "strings" would do to extract the function body, which is
>> probably all that you really n
> Hi,
>
> I'm using serial fields to generate IDs for almost all object in my
> database. I insert an empty row, get the CURRVAL() of the sequence
> and then update to that value.
>
> I had understood (and now, I can't find the reference to back this up)
> that serial is implemented in such a w
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> > I'm using 7.1 Beta 3, which has been pretty
> stable up until now. This
> > morning, I went to export a function I spent 5
> hours debugging on on
> > Friday to text so that I could have a copy of the
> final version. To my
> > horror, the functio
Hi would it work to do a pg_dump -d or a pgdumpall, then look through
the dumped sql file?
I do that to retrieve PL/pgSQL functions from the database when I've
accidentally wiped or modified the source (not often, but it happens).
Regards and best wishes,
Justin Clift
Tom Lane wrote:
>
> "Jos
31 matches
Mail list logo
