suppose I've got two table:
laser_uni=# \d t1
Table "public.t1"
Column | Type | Modifiers
+--+---
name | text |
addr | text |
laser_uni=# \d t2
Table "public.t2"
Column | Type | Modifiers
+-+---
name | text|
len| integer |
of
Ron,
the idea is to provide a table where users can define filters. But it
this table may be as well empty.
Alex
Ron Johnson wrote:
On Sun, 2003-08-31 at 11:56, Alex wrote:
Hi,
I have a query where I want to filter out records from table_a if a
field in table_a matches in table table_b. Ba
Hi,
I have tables that have default records that must not be deleted or
modified.
Is there an easy way to do this. Like setting a trigger on the Primary
key value ?
Alex
---(end of broadcast)---
TIP 2: you can get off all lists at once with the
On Sun, Aug 31, 2003 at 07:37:47PM -0400, Bruce Momjian wrote:
> Ron Johnson wrote:
> > Well, there's this:
> > http://www.fsf.org/licenses/gpl-faq.html#LinkingWithGPL
> > and this:
> > http://www.fsf.org/licenses/gpl-faq.html#LinkingOverControlledInterface
> > http://lists.gnupg.org/pipermail/gnup
Alex <[EMAIL PROTECTED]> writes:
> Hi,
> I have tables that have default records that must not be deleted or
> modified.
> Is there an easy way to do this. Like setting a trigger on the Primary
> key value ?
You could do this--create ON UPDATE and ON DELETE triggers that look
for distinguishing f
Given this table:
CREATE TABLE test ( id SERIAL, example TEXT );
An implicit sequence is created as show in this message:
NOTICE: CREATE TABLE will create implicit sequence 'test_id_seq' for
SERIAL column 'test.id'
How do I retrieve the last 'id' that was inserted? I have a process
that doe
Weiping He wrote:
suppose I've got two table:
laser_uni=# \d t1
Table "public.t1"
Column | Type | Modifiers
+--+---
name | text |
addr | text |
laser_uni=# \d t2
Table "public.t2"
Column | Type | Modifiers
+-+---
name | text|
len
Martijn van Oosterhout wrote:
> > Right, dynamic linking is a case where RMS would like the GPL to spread
> > the the closed-source binary, but I don't think he can legally do that.
> >
> > We do have that issue with our linking in of libreadline. We may adopt
> > libedit someday for that very re
On Sun, 31 Aug 2003, mgarriss wrote:
> First thought is "SELECT CURRVAL('test_id_seq');" but this assumes that
> there is only one connection inserting into this table, bad assumption.
That is what you should use, and it works for concurrent sessions. It's
all described in the manual:
http:/
Read the FAQ. Your currval assumption is wrong.
---
mgarriss wrote:
> Given this table:
>
> CREATE TABLE test ( id SERIAL, example TEXT );
>
> An implicit sequence is created as show in this message:
>
> NOTICE: CREATE
Jeffrey,
second solution is a beauty... thanks a lot.
Alex
Jeffrey Melloy wrote:
If I'm understanding you correctly, you can do something like:
select cola,
colb,
exists
(select 'x'
from tableb
where colc = colb)
from t
On Fri, 2003-08-29 at 04:11, Martijn van Oosterhout wrote:
> OIDs have never beebn unique, it's just that most databases never get big
> enough to experience wraparound. They are also now optional per table and
> may soon no longer be available by default.
It would be a god idea to remove the oid
On Sun, Aug 31, 2003 at 04:14:30PM -0400, Christopher Browne wrote:
> > Sure? My understanding is that it does break GPL. That's why there's an
> > LGPL.
> >
> > But since MySQL is double licensed and GPl is just one of the two it
> > gets even more complicated.
>
> No, actually, it's pretty simp
This is neither a GNU nor a MySQL mailing list. I suggest you take
your question to one of those places, as you'll get a better answer.
The question in it self was more general than PostgreSQL and MySQL.
However as I currently need to work with both of them I wanted to make
clear the actual
hi all,
i am planning to build a database (a dictionary in fact) that i will
eventually want to distribute on a cd (or downloadable iso). what i would
like to know is if this is technically possible with postgresql. and how
exactly would it be done? would i have to make postgresql run off the cd,
Op 26 Aug 2003 (12:38), schreef Robert Treat <[EMAIL PROTECTED]>:
> On Tue, 2003-08-26 at 07:28, Jules Alberts wrote:
> > Hello everyone,
> >
> > I'm working on a tiny trigger function that needs to ensure that all
> > values entered in a field are lowercase'd. I can't use pl/pgsql
> > because I h
Hi,
I'm really happy to see that pgadmin3 will run on Linux!
I tried to build it on Gentoo but got errors.
Was anybody of you able to build it for Gentoo or will there be an
emerge file?
Regards,
Christian
---(end of broadcast)---
TIP 3: if postin
17 matches
Mail list logo
