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
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
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]
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
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
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
"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
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
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
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
11 matches
Mail list logo
