Am Mon, 16 Jun 2008 11:48:01 +1000
schrieb novice [EMAIL PROTECTED]:
You are watching for the lpad() function ...
I have a table
CREATE TABLE problem (
problem_id integer,
solution_count integer
);
INSERT INTO problem VALUES (1001, 4);
INSERT INTO problem VALUES (1012, 11);
am Mon, dem 16.06.2008, um 11:48:01 +1000 mailte novice folgendes:
I have a table
CREATE TABLE problem (
problem_id integer,
solution_count integer
);
INSERT INTO problem VALUES (1001, 4);
INSERT INTO problem VALUES (1012, 11);
SELECT * from problem;
problem_id |
am Mon, dem 16.06.2008, um 11:48:01 +1000 mailte novice folgendes:
I have a table
CREATE TABLE problem (
problem_id integer,
solution_count integer
);
INSERT INTO problem VALUES (1001, 4);
INSERT INTO problem VALUES (1012, 11);
SELECT * from problem;
problem_id |
Perfect!
Thank you very mcuh :)
2008/6/16 A. Kretschmer [EMAIL PROTECTED]:
am Mon, dem 16.06.2008, um 11:48:01 +1000 mailte novice folgendes:
I have a table
CREATE TABLE problem (
problem_id integer,
solution_count integer
);
INSERT INTO problem VALUES (1001, 4);
INSERT INTO
Hi,
Not to say which is better or worse, I find the use
of lpad() interesting as well:
select problem_id,
lpad (cast(solution_count as varchar), 9, '0')
from problem;
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] on behalf of novice
Sent:
hi guys.
I want know if it's possible create a select from 2 database or create
a view in one of them.
--
Jorge Andrés Medina Oliva.
Systems Manager and Developer.
BSDCHiLE.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
On 17/06/2008, Jorge Medina [EMAIL PROTECTED] wrote:
hi guys.
I want know if it's possible create a select from 2 database or create
a view in one of them.
The short answer is no.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
Helo
it is possible if you don't mind some work :)
We are doing it with plproxy.
Simple scenario would be
1. install plproxy
2. create sql functon with needed sql in remote db
3. create plproxy function in current db
4. create sql or function that combines the results from data in current db
and
This is a very cool animation for your
amusement, amazement and edification.
http://www.vimeo.com/1081680
TJ O'Donnell
http://www.gnova.com/
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql