"Mike Cox" <[EMAIL PROTECTED]> wrote in message
Well, yes. You have to be a member of the mailing list you want to
post to even if you are posting through usenet. Otherwise your post
will bounce to you *email* account. Half of those who respond even
when you are a member of the list, respond via
Shawn Harrison wrote [01/28/05 3:53 PM]:
I have a table like this:
create table objects (
id serial primary key,
name varchar not null,
parent integer references objects(id) default 1 not null,
urivarchar not null
) without oids;
The uri column is a denormalization
Shawn Harrison wrote [01/31/05 12:56 PM]:
Shawn Harrison wrote [01/28/05 3:53 PM]:
create or replace rule objects__update as on update to objects
do instead (
update objects_data set
name = new.name,
typename = new.typename,
parent = new.parent
PFC wrote [01/28/05 7:08 PM]:
First you should use a ltree type for the uri field :
Yes, it would be very good if I could use ltree rather than rolling my
own, but ltree doesn't meet my use requirements.
- you write it foo.bar instead of /foo/bar
That is the problem: The point is to make look
lution to my problem.
Best regards,
Andrey V. Semyonov
Take care,
Shawn Harrison
--
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail comman
e, and play with permissions? (Yuck.) Do I need to bite the
bullet, go back to cascading triggers, and work out the data visibility
voodoo and the efficiency issue? Or is there a better way that I haven't
thought of?
Thanks,
Shawn Harrison
--
[EMAIL PROTECTED]
Frank D. Engel, Jr. wrote [01/27/05 9:19 AM]:
On Jan 26, 2005, at 6:57 PM, PFC wrote:
Isn't there some free open source algebraic computation toolkit with
equations and units somewhere ?
A very simple but effective system that I have used quite a lot for
"computation with units" is a Python modul
Craig Bryden wrote [01/07/05 3:46 AM]:
Hi
I have vast experience working with MS-SQL. Which books would be good
for me to use in order to teach myself PostgreSQL? I need to migrate a
MS-SQL Db to PostgreSQL. It contains tablers,views,stored procs, and
user defined functions.
With no other RDBMS
Joe,
That's cool! Thanks for the tip. It looks like your "branch" is my
"ancestry". I'll look in contrib more often. I could use connectby() instead
of my homebrew plpgsql functions.
Shawn
- Original Message -
From: "Joe Conway" <[EMA
view articles_objects (
select documents_objects.*, title from documents_objects, articles
where documents_objects.id = articles.id;
FWIW,
Shawn Harrison
- Original Message -
From: "Alex Satrapa" <[EMAIL PROTECTED]>
To: "PostgreSQL General" <[EMAIL PROTECTED
y be fixed in a future release. My
question is, are there any definite plans in that direction at this point?
Take care,
Shawn Harrison
---(end of broadcast)---
TIP 8: explain analyze is your friend
11 matches
Mail list logo