1) Select t1.* from table_1 t1, table2 t2 where t1.column = t2.column;
2) Select t1.* from table_1 t1 join table2 t2 on t1.column = t2.column;
-Original Message-
From: Stephan Richter [SMTP:[EMAIL PROTECTED]]
Sent: Sunday, January 21, 2001 11:20 PM
To: [EMAIL PROTECTED]
Subject:
Jan Wieck wrote:
Forest Wilkinson wrote:
I have a database in which five separate tables may (or may not) reference
any given row in a table of postal addresses. I am using the primary /
foreign key support in postgres 7 to represent these references.
My problem is that, any time a
FYI, 7.1 will have a MySQL dump converter in /contrib.
[ Charset ISO-8859-1 unsupported, converting... ]
On Sat, 18 Nov 2000 01:13:23 +0200, Max Fonin said:
Can give a link ?
can do :
http://freshmeat.net/projects/mysql2pgsql/?highlight=convert+sql
i havent tried their's
Hello everyone,
I have to create table which stores user_id and their photo(gif format).
How to insert and get the photo of the users using Java Servlets?
--
Ramesh HR
Trainee Engineer
EASi Technologies
213, 3rd Main, 4th Cross
Chamrajpet, Bangalore - 560 018
India
Ph.: 660 1086 / 660 2365 /
Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
As it is known that any funtion, written in pl/pgsql, can only
retrun one tuple. I am just wondering it were true as well for function
written in C language. I need to write few function that will retrun
mulitiple rows satsifying a
Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
As it is known that any funtion, written in pl/pgsql, can only
retrun one tuple. I am just wondering it were true as well for function
written in C language. I need to write few function that will retrun
mulitiple rows satsifying a
FYI, we have a MySQL Perl script in 7.1beta. Would you please
check that and see if you have any enhancements? Thanks.
Hi.
MySQL-Postgres dump converter is now available at
http://ziet.zhitomir.ua/~fonin/code/my2pg.pl. Still beta and
bugsome version but working, supports MySQL ENUMs,