On Wed, 2 Apr 2008 23:54:18 -0300
"Osvaldo Kussama" <[EMAIL PROTECTED]> wrote:
> 2008/4/2, Ivan Sergio Borgonovo <[EMAIL PROTECTED]>:
> > I've
> >
> > create table types(
> > typeid int,
> > special boolean not null
> > );
> >
> > create table methods(
> > methodid int,
> > typeid refer
hai all,
I have a plpgsql function and I am using postgresl 8.1.9
CREATE OR REPLACE FUNCTION get_vehicle_id(INT) RETURNS SETOF RECORD AS
$BODY$
DECLARE
r RECORD;
int_day ALIAS FOR $1;
BEGIN
FOR r in SELECT fk_bint_old_vehicle_number AS vehicle_id
FROM tbl_rac_ve
am Thu, dem 03.04.2008, um 15:54:56 +0530 mailte Anoop G folgendes:
> hai all,
> I want to select dat_replacement between now () and now - 5 dyas or now -7
> days like that i want to pass the integer value as argument to the function.
I show you a similar solution:
test=*# select * from foo;
I have following table:
CREATE TABLE t1 (
"name" VARCHAR(500) NOT NULL,
"lid" INTEGER NOT NULL,
"accs" VARCHAR(20)[] NOT NULL
CONSTRAINT "t1_lid_key" UNIQUE("lid")
);
I interested in the possibility to speed-up search for rows like this:
SELECT lid
FROM t1
WHERE accs && ARRAY['item1','item
Hi all. I was wondering if it's possible for a trigger to perform operations
on a database on different server? I saw somewhere that there's a piece of
software that allows conneciotns between different databases, but what about
different servers? I also thought about using perl, would it be possib
On Wed, 2 Apr 2008, chester c young wrote:
> it appears I have a broken RI in my db.
>
> call_individual.clh_id references call_household.clh_id
>
> \d call_individual
> ...
> Foreign-key constraints:
> "call_individual_clh_id_fkey" FOREIGN KEY (clh_id) REFERENCES
> call_household(clh_id) ON D
Marcin Krawczyk wrote:
Hi all. I was wondering if it's possible for a trigger to perform operations
on a database on different server? I saw somewhere that there's a piece of
software that allows conneciotns between different databases, but what about
different servers? I also thought about using
Stephan Szabo <[EMAIL PROTECTED]> wrote:
> On Wed, 2 Apr 2008, chester c young wrote:
>
> > it appears I have a broken RI in my db.
> Yeah, that looks pretty broken. Can you reproduce this from a clean
> start repeatedly or is this a one off? Do you ever turn off triggers,
> perhaps by modifyin
On Thu, 3 Apr 2008, chester c young wrote:
>
> Stephan Szabo <[EMAIL PROTECTED]> wrote:
>
> > On Wed, 2 Apr 2008, chester c young wrote:
> >
> > > it appears I have a broken RI in my db.
>
> > Yeah, that looks pretty broken. Can you reproduce this from a clean
> > start repeatedly or is this a one
Thanks a lot, I'll give it a try.
regards
mk
2008/4/3, Shane Ambler <[EMAIL PROTECTED]>:
>
> Marcin Krawczyk wrote:
>
> > Hi all. I was wondering if it's possible for a trigger to perform
> > operations
> > on a database on different server? I saw somewhere that there's a piece
> > of
> > softwar
--- Stephan Szabo <[EMAIL PROTECTED]> wrote:
> Is it possible you ever had a before delete trigger that just did a
> return
> NULL rather than raising an exception? IIRC, explicitly telling the
> system to ignore the delete will work on the referential actions.
yes, it is possible, for example, a
On Thu, 3 Apr 2008, chester c young wrote:
> --- Stephan Szabo <[EMAIL PROTECTED]> wrote:
>
> > Is it possible you ever had a before delete trigger that just did a
> > return
> > NULL rather than raising an exception? IIRC, explicitly telling the
> > system to ignore the delete will work on the re
--- Stephan Szabo <[EMAIL PROTECTED]> wrote:
> > is it is possible, for example, a function without a body or
> without a "return old".
> >
> > are you saying this would override the RI constraint?
>
> If it returned something that would have prevented the delete without
> an error, yes.
this is
13 matches
Mail list logo