I have data in one table called articles and I would like to make a
function in which takes certain data from it and display the results.
Example:
CREATE TABLE articles (
article_id serial,
title varchar(200),
posted timestamp,
article_subject varchar(200),
article_body text,
allow_comments boole
Can I do something like this:
CREATE TABLE sample (id SERIAL, node INTEGER, parent INTEGER);
INSERT INTO sample(node,parent) VALUES(1,0);
INSERT INTO sample(node,parent) VALUES(2,0);
INSERT INTO sample(node,parent) VALUES(3,1);
INSERT INTO sample(node,parent) VALUES(4,3)
CREATE OR REPLACE FUNCTIO
Sorry for the attachment, but copying and pasting this data does not work.
I don't have any idea how to insert the type of data into PostgreSQL.
Basically, it's encrypted data in which I would like that keep raw format.
Thanks for any help,
J
sample_data.pdf
Description: Adobe PDF document
--
::1 is a function of the PHP $_SERVER[''] internal function, not a
PostgreSQL problem. It will display ::1 on any database, you program a
PHP custom function to call the whole IP address. The real question is
that a problem in a production environment? Of note, outside IP
addresses will display fi
I have a client who wants to use Delphi as a front end to a Database, I
would like to use PostgreSQL over MSSQL and have been looking at the
psqlodbc project. Will psqlodbc connect with Delphi 6? Basically, I'm
wondering if anyone has experience with it? Any help will be appreciated.
Thanks,
J
I have some clients that are looking to upgrade to MSSQL Server because
they use ACT!. I'm developing a web application for them that uses
PostgreSQL. Does anyone know if ACT! can use PostgreSQL? or if I can
hack it?
Suggestion welcome and Thanks,
J
---(end of broadcas
You're php install isn't finding the postgresql libs it needs. When you
do the ./configure --with-pgsql check the output of the config run, and
you'll see something like:
checking for PostgreSQL support... no
You may want to set include flags when compiling
CPPFLAGS=-I/usr/local/pgsql/inc
