[SQL] Combine 'left outer join' and 'inner join'

Hello, I have a problem with a sql request on Postgresql. It uses 'left outer join' and 'inner join' Here is my request: select a.acte_id,a.acte_libelle,a.acte_url_image,a.acte_page, a.acte_texte,a.acte_marge_texte,a.acte_date,a.acte_registre_page, commune.commune_id,commune.commune_nom,commune.

[SQL] Problem using Subselect results

Hi all, I want to use the result of a subselect as condition in another one. table1: a,b table2: a,c CREATE VIEW my_view AS SELECT b,c (SELECT a, b FROM table1 WHERE b=1) my_ab, (SELECT c FROM table2, my_ab WHERE table3.a=my_ab.a) my_c; this is just an example - i know i could cross join this o

Re: [SQL] Problem using Subselect results

> I want to use the result of a subselect as condition in another one. > > table1: a,b > table2: a,c > > CREATE VIEW my_view AS SELECT b,c > (SELECT a, b FROM table1 WHERE b=3D1) my_ab, > (SELECT c FROM table2, my_ab WHERE table3.a=3Dmy_ab.a) my_c; > > this is just an example - i know i could cros

Re: [SQL] Problem using Subselect results

SELECT my_c.b, my_c.c FROM (SELECT table2.b, table2.c FROM table2, (SELECT table1.a, table1.b FROM table1 WHERE (table1.b = 1)) my_ab WHERE (table2.a = my_ab.a)) my_c; You were doing what I wanted to avoid - you are using a "SUBSUBSELECT". But (now) I believe it's not possible to refer to a s

Re: [SQL] Problem using Subselect results

[EMAIL PROTECTED] wrote: SELECT my_c.b, my_c.c FROM (SELECT table2.b, table2.c FROM table2, (SELECT table1.a, table1.b FROM table1 WHERE (table1.b = 1)) my_ab WHERE (table2.a = my_ab.a)) my_c; You were doing what I wanted to avoid - you are using a "SUBSUBSELECT". What about: CREATE VIEW m

[SQL] PostgreSQL or pl/psSQL equivalent to MS SQL Server's xp_cmdshell?

Title: PostgreSQL or pl/psSQL equivalent to MS SQL Server's xp_cmdshell? Does anyone know of the PostgreSQL or pl/psSQL equivalent to MS SQL Server's xp_cmdshell?   This is the command that allows you issue command-line statements from within SQL, e.g., you would do xp_cmdshell 'dir c:\' if yo

Re: [SQL] PostgreSQL or pl/psSQL equivalent to MS SQL Server's

On Thu, 24 Jul 2003 [EMAIL PROTECTED] wrote: > Does anyone know of the PostgreSQL or pl/psSQL equivalent to MS SQL Server's > xp_cmdshell? This is the command that allows you issue command-line > statements from within SQL, e.g., you would do xp_cmdshell 'dir c:\' if you > wanted to see the cont

Re: [SQL] obtuse plpgsql function needs

Bruce-- Something for the todo list. This would be extremely handy. At minimum C functions should be able to ask the type of thing that was actually passed in and get a legitimate answer even if the type were a rowtype. This will also lead to the need for unnamed rowtypes, sooner or later. I k

Re: [SQL] min() and NaN

Greg Stark <[EMAIL PROTECTED]> writes: > Does postgres intend to support all the different types of NaN? Does you > intend to have +Inf and -Inf and underflow detection and all the other goodies > you actually need to make it useful? We have some of that; it needs work, and it's always going to be

Re: [SQL] min() and NaN

Tom Lane <[EMAIL PROTECTED]> writes: > NULL can be special, because it acts specially in comparisons anyway. > But NaN is just a value of the datatype. Does postgres intend to support all the different types of NaN? Does you intend to have +Inf and -Inf and underflow detection and all the other g

[SQL] silly NULL question

Howdy, I'm sure most of you PostgreSQL users out there will be able to answer this, but I'm just not finding the answer. Let's say I have a table called project that has three fields: field| type --- id int name varchar(30) parent_id int right now there is

Re: [SQL] silly NULL question

> Would return the row. Now with an upgrade to PostgreSQL 7.3 (yes, I know > there are many changes and we're working through them right now) the same > query returns nothing. Dropping the "AND parent_id = NULL" returns the row > as expected. NULL is similar to UNKNOWN. So, NULL = NULL is the s

Re: [SQL] silly NULL question

> "RT" == "Rod Taylor" <[EMAIL PROTECTED]>: RT> NULL is similar to UNKNOWN. RT> RT> So, NULL = NULL is the similar to UNKNOWN = UNKNOWN. Since you don't RT> know it, how can you tell if they're equal or not? RT> RT> Syntax you're looking for is: AND parent_id IS NULL ah, of course. Thanks

[SQL] Equivalent to sql%rowcount or @@rowcount

Hi All! is it possible to get in sql number of rows affected by the sql last insert, update or delete statement?? for eg, oracle - sql%rowcount. sqlserver select @@rowcount. Any help will be highly appreciated.. Thanks Regards, VijayCool new emoticons. Lots of colo