[GENERAL] String search?

1999-12-29 Thread Peter Landis
ECT syntax for finding words in the database, but this is assuming that the word is exactly the same. If anyone could advise me on this minor problem, I would greatly appreciate it. Peter Landis __ Do You Yahoo!? Talk to your friends online

[GENERAL] LEFT OUTER JOIN?

2000-05-24 Thread Peter Landis
Hi- I'm a newbie at postgres but have a pretty good understanding of SQL statements. I have created two views and wanted to do a LEFT OUTER JOIN of the two tables. The sytax is select * from vcompany LEFT OUTER JOIN ON vcompany.id=vregistry.id; I get the following error: LEFT OUTER JOIN not

[GENERAL] postgresql and perl?

2000-05-25 Thread Peter Landis
Hi- I'm a newbie at postgresql and was working on sorting by category. What my question is, how do you sort by category when using a variable. For instance, you can sort by name in perl by doing: $sqh = $dbh->prepare(q{select name from company order by name;}); $sqh->execute(); but what if