|
by: My Internet |
last post by:
Hello,
I want to know if in PostgreSQL, there is a command equivalent to START
WITH... CONNECT BY from Orcale?
This command is used to traverse a tree.
Thank you,
Jean-Marc
_________________________________________________________________
|
by: D. Dante Lorenso |
last post by:
I have a simple table that I'd like to query to pull
out a heirarchy from a tree relationship. What is the
best way to do this without a 'CONNECT BY' clause like
Oracle has?
Example
mytable
+----------+-----------+
| child_id | parent_id |
|
by: Rick Hickerson |
last post by:
I can't get PHP to connect to DB2 on the same server.
I'm running both Apache/PHP and DB2 on Mandrake Linux 9.2. I didn't compile
PHP; just installed what appear to be the appropriate RPMs (I don't like to
compile/install and ruin RPM dependencies; I've seen the documents which say to
build PHP "--with-ibm-db2=/home/db2inst1/sqllib"):
unixODBC-2.2.6-4mdk
libunixODBC2-2.2.6-4mdk
php-mysql-4.3.2-3mdk
|
by: Carlos Ojea Castro |
last post by:
Hello:
In kylix3 I made a SQLConnection component (called 'SQLConnection1') to
connect to a PostgreSQL database. I started the PostgreSQL server so
Object inspector shows 'Connected: True' on that object.
Then I made a SQLDataSet component (called 'SQLDataset1').
On 'SQLDataset1' I set SQLConnection to 'SQLConnection1', CommandType to
'ctQuery' and CommandText to 'SELECT * FROM pc104' (pc104 is a valid
table name).
|
by: vicky |
last post by:
Hello Experts,
Trying to run sample Postgrel's ECPG(Embedded
SQL)programs on RHL 9.0.
Im unable to connect to PostgreSQL database (sirishadb) when I run
the program ....
# su postgres (enter)
|
|
by: David Parker |
last post by:
I know this question has been discussed, probably multiple times, but I
can't seem to access archives.postgresql.org today....
I need to select all the rows in a table with two fields: parent_id and
child_id that participate in the same logical "tree". In other words,
given an id value, I want to find where child_id = my-value, and then
retrieve the values in the tree above it.
The functionality I'm looking for is essentially the...
|
by: Deepa K |
last post by:
Hi,
I am using postgresql 7.1.3 in RedHatLinux 7.2. Can anyone tell me how
to connect with postmaster through TCP socket (it is started with -i
option) using libpq from an external application. (written in C)
--
regards,
Deepa K
---------------------------(end of broadcast)---------------------------
|
by: Clodoaldo Pinto |
last post by:
Can't connect to postgresql server
php error log message:
PHP Warning: pg_connect() : Unable to connect
to PostgreSQL server: could not connect to server: Permission
denied\n\tIs the server running on host "127.0.0.1" and
accepting\n\tTCP/IP connections on port 5432?
php connection string:
|
by: charles.leviton |
last post by:
Hi all,
I am running on Win XP. I have installed Apache 2.2. Works fine.
I have installed php-4.4.4-Win32 manually.
Apache to php connection is working fine, I tested a couple of trivial
php scripts.
I have installed PostGreSQL v8. I can do stuff (create table, populate
data) thru pgAdminIII tool, so I think that is also fine.
I want to install phpBB. When I try to do the set up I get message
|
by: irhernan |
last post by:
Hi,
I have just installed a postgresql server on a windows server. Now, I want to connect to it from a winodws desktop through http (intranet).
What URL will I have to use to connect to the remote db server?
Many thanks in advance..
regards,
Mike
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|