Thanks Markus for your help (in message "How the
R-Tree index works?"), but I guess, I should be more specific in my question.
I have the next situation:
1- A table (A) with data, for
example:
ID
| what |
time |
howmuch
On Tue, Sep 10, 2002 at 09:45:16PM +0200, Michael Paesold wrote:
>
> Adam Erickson wrote:
>
> > Correct me if I'm wrong, but rules constrain the SQL (ie. validation).
> > Triggers are carried out after the SQL is executed and the data is
> modified.
> > So, to answer your question, I think rules
Peter Atkins wrote:
> All,
>
> Is there a way to easily change the type of column? Or do I have to drop
> and create again.
>
> From:
> assignment_notes | character varying(255)
>
> To:
> assignment_notes | text
Do that kind of change will require creating a new table, copying the
data, drop
Adam Erickson wrote:
> Correct me if I'm wrong, but rules constrain the SQL (ie. validation).
> Triggers are carried out after the SQL is executed and the data is
modified.
> So, to answer your question, I think rules come first. As to which order
> the rules / triggers are executed probably de
Correct me if I'm wrong, but rules constrain the SQL (ie. validation).
Triggers are carried out after the SQL is executed and the data is modified.
So, to answer your question, I think rules come first. As to which order
the rules / triggers are executed probably depends on the order you put them
Hi all,
can you tell me in what order rules and triggers are executed?
First, what comes first, the rules, or the triggers?
And then, in what order are all the rules / triggers executed?
Regards,
Michael Paesold
---(end of broadcast)---
TIP 6: H
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Tue, 10 Sep 2002, Goran Buzic wrote:
>> id1char(6) NOT NULL CHECK(id1 ~* '^([0-9]{1,2}\.){2}$'),
> Bad column type choice. char(6) is space padded, so 1.2. looks like
> "1.2. ". For me, 12.12. works, but any shorter one fails. Unless
> you ne
On Tue, Sep 10, 2002 at 08:35:27AM -0500, Josh Jore wrote:
> On Tue, 10 Sep 2002, Goran Buzic wrote:
>
> > id1char(6) NOT NULL CHECK(id1 ~* '^([0-9]{1,2}\.){2}$'),
>
> > ERROR:ExecAppend: rejected due to CHECK constraint table_name1_id1
> >
> > I tested preceding regular expression w
On Tue, 10 Sep 2002, Goran Buzic wrote:
> Hi
>
> Can anybody help me with POSIX-style regular expression used to check rules
> that new data must satisfy for an insert or update operetion.
>
> Table was created as follows.
>
> CREATE TABLE table_name1 (
> id1char(6) NOT NULL CHECK(id1 ~*
On Mon, Sep 09, 2002 at 11:02:27PM +0200, Reinoud van Leeuwen wrote:
> On Mon, 9 Sep 2002 18:16:07 + (UTC), [EMAIL PROTECTED] (Charles
> Hauser) wrote:
>
> >I am trying to port a Sybase table create script to one usable for
> >postgreSQL.
> >
> >(note I am not a DBA)
> >
> >In particular I am
On Tue, 10 Sep 2002, Goran Buzic wrote:
> id1char(6) NOT NULL CHECK(id1 ~* '^([0-9]{1,2}\.){2}$'),
> ERROR:ExecAppend: rejected due to CHECK constraint table_name1_id1
>
> I tested preceding regular expression with Perl and JavaScript and it worked
> fine. Can I use regular expressio
Hi
Can anybody help me with POSIX-style regular expression used to check rules
that new data must satisfy for an insert or update operetion.
Table was created as follows.
CREATE TABLE table_name1 (
id1char(6) NOT NULL CHECK(id1 ~* '^([0-9]{1,2}\.){2}$'),
id2INT NOT NULL,
CON
Hallo !
I have problem find out distribution of PostgreSQL for windows.
Can you help me, or send me some url links, where I will find it.
Thanks.
Juraj S,
---
Bc. Šimko Juraj
Juraja Kréna 6
915 01 Nové Mesto nad Váh
On Mon, 9 Sep 2002 18:16:07 + (UTC), [EMAIL PROTECTED] (Charles
Hauser) wrote:
>I am trying to port a Sybase table create script to one usable for
>postgreSQL.
>
>(note I am not a DBA)
>
>In particular I am not well versed on how to use/recode the stored
>procedures such as that in the exampl
14 matches
Mail list logo
