Thread: Question on PL/Perl

Question on PL/Perl

From
Deepblues
Date:
Hi,

 I'm new to PostgreSql and i'm wondering how to write functions in
PL/Perl to INSERT, RETRIEVE, DELETE  elements from the tables.
I have 3 tables and I have to write functions in perl to populate data
to the tables.

Any input would be appreciated. I tried online help but it doesn't
seem to be appropriate.

Deepblues

Re: Question on PL/Perl

From
"Mike G."
Date:
What version of Postgres are you running?  Perl in 8.0 is different from earlier versions.

On Mon, Feb 14, 2005 at 01:11:19PM -0600, Deepblues wrote:
> Hi,
>
>  I'm new to PostgreSql and i'm wondering how to write functions in
> PL/Perl to INSERT, RETRIEVE, DELETE  elements from the tables.
> I have 3 tables and I have to write functions in perl to populate data
> to the tables.
>
> Any input would be appreciated. I tried online help but it doesn't
> seem to be appropriate.
>
> Deepblues
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match

Revision Control

From
Date:
i'm working with data that requires revisions.

the easiest way to think about it is a product by
revision.  for example,

product A, rev 1
product A, rev 2
product A, rev 3

where is revision is potentially a viable product to
some customer.  iow, customer blue may order product
A, rev 3 and customer green may want product A, rev 1.

i have put some thought into this and developed the
following scheme...

three tables (T=table, C=column in table, PK=primary
key, FK=foreign key):

T product_base
C PK product_base_id
C product_number
C product_name
C product_description

T revision
C PK revision_id
C revision_number
C revision_description

T product_revision
C PK product_revision_id
C FK product_base_id
C FK revision_id

does this seem like a reasonable approach to solving
this problem?  please let me know if you have a better
approach or more information to improve this approach.



__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250

Re: Revision Control

From
brew@theMode.com
Date:

operationsengineer1@yahoo.com......

So you have three tables:

> T product_base
> T revision
> T product_revision

I don't understand the difference between revision and product revision.
Maybe product_revision is a cross reference of the first two tables?

What kind of queries would you make?  I don't really see the sense of
asking what products have a revision 4.  What are these products anyway?

Maybe it would make sense to ask who uses a product a revision 4 level,
but you don't have a users table.

I think we need more info as to what you are trying to do.

brew

 ==========================================================================
                  Strange Brew   (brew@theMode.com)
  Check out my Stock Option Covered Call website  http://www.callpix.com
     and my Musician's Online Database Exchange http://www.TheMode.com
 ==========================================================================