Thread: Question on PL/Perl
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
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
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
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 ==========================================================================