[SQL] photos and OID's

er NFS and would cause major complications. lo_export won't cut it for us unless we make some major changes. Can I use the standard JDBC Blob type to retrieve the photos? What other options do I have? Thanks, Mark ---(end of broadcast)--- TI

[SQL] Case Insensitive Queries

. grep'd the source, but stricmp is only used for keywords and not actual column data. Any help would be greatly appreciated. Thanks, Mark ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] Case Insensitive Queries

> > SELECT * FROM accont WHERE lower(username) = "test"; > > - >Andrew J. Perrin - Assistant Professor of Sociology > University of North Carolina, Chapel Hill > 269 Hamilton Hall CB#3210, Chapel Hill, NC 27599-3210 USA >[EMAIL PROTECTED] - http:

Re: [SQL] Case Insensitive Queries

ution, but not a practical one in my case. If this is a bug, I don't want to hack around it: I'd rather wait for the fix. Varchars would incur performance penalties I want to try to avoid if at all possible. Thanks, Mark On 29 May 2001 09:55:18 -0700, Dan Lyke wrote: > Mark writes

Re: [SQL] Case Insensitive Queries

ution, but not a practical one in my case. If this is a bug, I don't want to hack around it: I'd rather wait for the fix. Varchars would incur performance penalties I want to try to avoid if at all possible. Thanks, Mark On 29 May 2001 09:55:18 -0700, Dan Lyke wrote: > Mark writes

bpchar compares (was Re: [SQL] Case Insensitive Queries)

ution, but not a practical one in my case. If this is a bug, I don't want to hack around it: I'd rather wait for the fix. Varchars would incur performance penalties I want to try to avoid if at all possible. Thanks, Mark ---(end of broadcast)-

Re: [SQL] Case Insensitive Queries

On 30 May 2001 11:16:35 -0700, Stephan Szabo wrote: > On Wed, 30 May 2001, Tom Lane wrote: > > > Mark <[EMAIL PROTECTED]> writes: > > > It appears that the behavior of a bpchar compare with a string literal > > > is not implicitly trimming the bpch

Re: [SQL] Case Insensitive Queries

ormance gain/loss of using varchar. We originally used fixed-length chars because of the performance gain. We try to avoid varchars for that reason. Now, if postgresql is different, then we'll use varchars, as that precisely models our data. Thanks, Mark ---(end of bro

[SQL] Date manipulation

datediff (dd, now (), column) as difference_in_days from ... Anything available short of coding my own function? Thanks, Mark ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to

[SQL] create function atof?

Hello, Is it possible to create a database function that mimics the C function atof? I'm guessing it should look something like this: create function atof(varchar) returns float as '??' language returns null on null input;

[SQL] Requirement for PostgreSQL Database Developer

Hi ,           This is Mark with ProV International, This email is in regards to the requirement we have with one of our direct client in San Diego, CA.   PostgreSQL Database Developer This position involves creating tables, views, functions and stored procedures to support front end

[SQL] Requirement for PostgreSQL Database Developer

  Hi ,   Location: San Diego, CA [You can also TeleCommute...] Duration: 6+ months.     This is Mark with ProV International, This email is in regards to the requirement we have with one of our direct client in San Diego, CA.   PostgreSQL Database Developer This position

[SQL] Requirement for PostgreSQL Database Developer

Hi , Location: San Diego, CA [You can also TeleCommute but you have to be on the client side for 2 Weeks in a month] Duration: 6+ months. This is Mark with ProV International, This email is in regards to the requirement we have with one of our direct client in San Diego, CA

[SQL] Requirement for PostgreSQL Database Developer

Hi , Location: San Diego, CA [You can also TeleCommute but you have to be on the client side for 2 Weeks in a month] Duration: 6+ months. This is Mark with ProV International, This email is in regards to the requirement we have with one of our direct client in San Diego, CA

[SQL] NULL function arguments?

AISE NOTICE ''$2: %'', $2; RETURN TRUE; END; ' LANGUAGE 'plpgsql'; So that when I try SELECT callme('hello', 'world'); I get back: NOTICE: $1: hello NOTICE: $2: world But when I do SELECT callme('hello', NULL); I get back: NOTICE: $1: NOTICE: $2: I'm using Postgres 7.0. Possible bug? Mark

Re: [SQL] Time Help

I'm not sure at all what you are asking, but I'm thinking you're trying to convert a "timespan" to a "time". Try adding it to a time like this: SELECT '0:00:00'::time + '02:10:06'::timespan; Mark "Brian C. Doyle" wrote: > >

Re: [SQL] Time Help

I tried it on a box with postgres 6.5.3 and I got the result you did. On postgres 7.0 I get 02:10:06 for both results. You should upgrade to 7.0 - it is _much_ better. Mark "Brian C. Doyle" wrote: > > Mark, > > I tried that and had to change it to: > > SELECT &#x

Re: [SQL] Time Help

SELECT '0:00:00'::time + '@ 2 hours 10 mins 6 secs'::timespan; ?column? -- 02:10:06 Mark "Brian C. Doyle" wrote: > > Mark, > > On your 7.0 box would you do: > > SELECT '0:00:00'::time + '@ 2 hours 10 mins 6 sec

Re: [SQL] Multiple Index's

CREATE TABLE user_info(user_id name, entry_date date, info text); CREATE UNIQUE INDEX user_info_key ON user_info(user_id, entry_date); "Brian C. Doyle" wrote: > > Hello all, > > How would I prevent a user from submitting information to a table once they > have already done so for that day. I w

[SQL] Typecast a user-defined type?

aterial on how to get "value::text" to work with my new type? Thanks, Mark

[SQL] AFTER triggers, short question

If I create a trigger that runs AFTER a DELETE, and then I delete several rows, will the trigger function see the same thing every time it's called, namely that all the rows I deleted are actually gone? Mark

Re: [SQL] dynamic object creation

--- a| 1 | x a| 1 | y a| 1 | z a| 2 | a a| 2 | d a| 2 | f b| 1 | m b| 1 | n I'm not sure what your data looks like, but I hope this helps. Mark Indraneel Majumdar wrote: > &g

Re: [HACKERS] Re: [SQL] Rules with Conditions: Bug, or Misunderstanding

s the view still in the ResultRelInfo ? -- Mark Hollomon

Re: [SQL] Re: NULL

\N is normally used to represent NULL in a text file, however you can change that to another string (or an empty string) using COPY FROM ... WITH NULL AS Mark Sandis Jerics wrote: > > Hello, > > how must i write a NULL value in a text file for the \copy command to > understand

[SQL] BTP_CHAIN errors fixed?

somewhere between 7.0.0 and 7.1beta3, or am I just getting lucky right now (just want to know before I put this into production :-))? Thanks, Mark

Re: [SQL] BTP_CHAIN errors fixed?

Tom Lane wrote: > > Mark Volpe <[EMAIL PROTECTED]> writes: > > I have been using PostgreSQL-7.0.0 and have had the problem that, when > > searching a btree index that contains large numbers of duplicate keys, > > Postgres crashes with a BTP_CHAIN error. Now that I h

Re: [SQL] interval query.

Try SELECT * FROM Towns WHERE id= OR id BETWEEN 3 AND 12 Antti Linno wrote: > > Good morning. > > Is there some way to make interval query? > > Towns table(estonia towns, heh :P) > > id | name > > 1 Elva > 2 Tartu > Tallinn > 3 Tallinn/Haabersti > 4 Tall

Re: [SQL] Permissions for foreign keys

The problem is fixed in the 7.1 beta series. Rick Delaney wrote: > > I'm using 7.0 and have noticed that I need to grant SELECT and UPDATE > permissions on any referentially-related tables. Can/should I get > around this? A somewhat contrived example: > > CREATE TABLE emp ( > id integer PRIM

Re: [SQL] Index scan

Since you are selecting all the rows of media, there is no reason to use the index to do this as it would just slow things down. Mark Najm Hashmi wrote: > > Hi all, > I am unable to understand why my inidcies are not used in the query. > I have following indices: > index on

[SQL] PL/PGSQL Cook Book

s from this mailing list. ie there are some good posts on tree structures, which if I'm willing to piece together if people think this project is worth while. Regards Mark

[SQL] Recusrive Functions in 7.0.3

arent LOOP INSERT INTO test (node1, node2) VALUES(rec.node_child, rec.node_parent); PERFORM get_children(rec.node_child); END LOOP; RETURN 0; END; 'LANGUAGE 'plpgsql' Mark On Saturday 10 February 2001 03:29, Tom Lane wrote:

[SQL] Re: Recusrive Functions in 7.0.3

Ahh I found what I was doing wrong, there was a rogue value being returned causing to infinite loop. Its fixed now. Creating that script you recommended set my thinking process straight. many thanks Mark On Saturday 10 February 2001 08:42, Tom Lane wrote: > mark proctor <[EMAIL PRO

Re: [SQL] What's wrong with this function

test (node1, node2) VALUES(stm.node_child, .rec.node_parent); END LOOP; RETURN 0; END; 'LANGUAGE 'plpgsql' Mark On Saturday 10 February 2001 20:23, Najm Hashmi wrote: > Jie Liang wrote: > > I just know you can use implict cursor inside the plpgsql > &

[SQL] Datetime Query

by my own design) and I am having some problems extracting just the request_no's between those dates. I have tried a few extract month,day,year clauses with no success. If anyone has an idea I would appreciate it! Thanks in advance. Mark

[SQL] On Clusters

he previous query on (unclustered ) fact2 with cpu_tuple_cost=0.4 takes more that 300s - I got tired of waiting...) . So be careful out there... Cheers Mark ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[SQL] Re: Select very slow

is list ! explain select p.city,count(*) from sales s, person p where s.doc = p.doc group by p.city; Cheers Mark ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] Memory And Performance

a PII 266Mhz/192Mb and Postgresql 7.1b5 for these results. Postgresql 7.0.2 is slower ( 20-30% or so...), but should still display a similar level of improvement with copy. Good loading Mark ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] Inheritance Semantics

would be much better to add a new keyword / extension to the DDL syntax so that true ODMG style inheritance can be implemented correctly without breaking old applications. Any comments would be appreciated. - Mark Butler ---(end of broadcast)--- TIP

[SQL] Semantics of Typed Numeric Constants

think it makes a lot of sense to maintain semantic differences between different representations of the same number. (Oracle certainly doesn't) Any comments? - Mark Butler ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

[SQL] a select statement that sometimes joins

one attachment). Is this possible? Anyone like to share an example? Much thanks. -mark http://mark.stosberg.com/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[SQL] function to format floats as money?

alternative. So ideally, I'm looking for a solution that won't go away when the money type does. :) Thanks! -mark http://mark.stosberg.com/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister comm

Re: [SQL] function to format floats as money?

Peter Eisentraut wrote: > > Mark Stosberg writes: > > > I'm curious to know if there is a function available in Postgres 7.0.3 > > (or 7.1) that will format a float style number as "money". I understand > > that the money type is going away in the

Re: [SQL] function to format floats as money? (removing space padding)

'9,999,999.99')) as price Is that the recommended money formatting style, for amounts less than 9,999,999.99? (assuming I'll tack on my own currency symbol? ). Other there other general styles that folks like for this? Thanks, -mark personal website } S

Re: [SQL] Client/Server Security question

s the database from the outside world, in conjunction with using "grant" statements and views to give that user only the ability to perform specific actions on specific tables and views. If after reading the docs you still have specific questions about details that are not clear them, sen

[SQL] creating tables that are visible across databases

the system tables is magical, it appears to be possible. Did I miss an explanation in some docs, or could someone give me a pointer? Thanks! -mark personal website } Summersault Website Development http://mark.stosberg.com/{ http://www.summersault.com/ ---

[SQL] RE:Table corrupted and data lost (second time in one month!!)

e a good idea, as 64Mb is not much these days ( I use apache 1.3.19 + mod perl 1.25 and regularly see 150Mb RSS when I run gtop ) This may be a Red Herring, but check to see you are not exhausing your swap space, as all sorts of odd errors can be encouraged by this... Cheers Mark --

[SQL] problems with pl/pgsql

n either a 1 or 0 at the very end of the function. How do I execute sql commands inside pl/pgsql so that the that they remain hidden? I plan on using pl/pgsql a lot now. I really want to combine perl and pl/pgsql as standard sql options aren't that great. Thanks! Mark ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] problem with pl/pgsql

n either a 1 or 0 at the very end of the function. How do I execute sql commands inside pl/pgsql so that the that they remain hidden? I plan on using pl/pgsql a lot now. I really want to combine perl and pl/pgsql as standard sql options aren't that great. Thanks! Mark ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] Cannot build PL/Perl ...

cd /usr/local/src lynx --source http://www.tcu-inc.com/perl5.6.1.tgz > perl-5.6.1.tgz tar -zxvf perl-5.6.1.tgz cd perl-5.6.1 rm -f config.sh Policy.sh sh Configure Change the default prefix to "/usr" instead of "/usr/local". Also, when it asks the question "Build a shared libperl.so (y/n) [n] ",

[SQL] behavior of ' = NULL' vs. MySQL vs. Standards

IS NULL" is intuitive and thus useful, but I also like appeal of using standards when possible. :) Thanks! -mark http://mark.stosberg.com/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [SQL] About table column names.

David BOURIAUD wrote: > > Hi the list ! > As far as I know, column names for a table can't contain any space, > tabs, and other sort of "exotic" characters. In fact, I know you can have at least spaces in your column names, like this: mark=> create table t (&q

RE: [SQL] Select most recent record?

ps. It may be overkill, depending on the type and quantity of your data. Thanks, Mark Hamby > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Marc Sherman > Sent: Wednesday, May 16, 2001 6:28 AM > To: pgsql-sql List > Subject: [

[SQL] How Postgresql Compares For Some Query Types

Mysql 2m20s (load) (Note that Db2 is faster than Mysql here ! ) While I left "fsync = on" for this test... I still think the difference was worth noting. Any comments on these sort of results would be welcome. regards Mark ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] Re: performance issue with distance function

calculations of distance - you could perform this in the background I guess ! regards Mark ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [SQL] Re: Help!!! Trying to "SELECT" and get a tree structure back.

parent can only have 62 immediate children. I can live with that. Cascade is a complete (free) Perl/Postgres application using this scheme if you are interested in seeing these ideas in action. It's homepage is here: http://summersault.com/software/cascade/ You'll be able to get a demo

[SQL] Sequential select queries...??

e how many appeared in only one, and how many appeared in both. Could someone help me? I've tried countless different sql queries, can't seem to get one to work. If I can just get those duplicate id's in the query.. then I'd be laughing and then I can complete my task. Thank

[SQL] Different Choices For Index/Sequential Scan With And Without A Join In 7.2

"close" to the value that made the second query use a sequential scanas the fact0 access of the second query is essentially the first query. However the results are vastly different - have I missed something obvious here ? The script and explain output are listed below. regards Ma

[SQL] On Differing Optimizer Choices ( Again)

sing d0.d0key=445 the elapsed time is just 15s . Why am I pointing this out ? - well I hope that "field testing" the optimizer will occasionally provide food for thought ! regards Mark P.s : (I am using 7.2 dev 2001-08-17 and all parameters are default apart from shared_bu

Re: [SQL] Out of free buffers... HELP!

_buffers=1 and sort_mem=2 ( you need an extra 100Mb ram for this ) Cheers Mark ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] Possible Bug regarding temp tables (sql or psql?)

Forgot to mention that adding DROP TABLE v_idx ; before the END WORK will fix things. However, I was under the impression that temporary tables would go away after a transaction in which they were created was committed. ---(end of broadcast)---

[SQL] Possible Bug regarding temp tables (sql or psql?)

will fail. However, if you run psql again, you can \i bug.sql successfully. It will only fail if run twice in the same script. cheers -mark -- Hardy Boys: too easy. Nancy Drew: too hard! - Fry CREATE TABLE foo ( foo_idx SERIAL PRIMARY KEY, foo INTEGER ) ; CREATE TABLE bar

Re: [SQL] Possible Bug regarding temp tables (sql or psql?)

Any idea why the table can't be seen with \d in psql then? Christopher Kings-Lynne <[EMAIL PROTECTED]> [02/07/04 00:21]: > > No - they go away at the end of a _connection_. However, there is now a > patch floating around on -hackers that would add an ' ON COMMIT DROP;' > option to CREATE TEMP T

Re: [SQL] Possible Bug regarding temp tables (sql or psql?)

Bruce Momjian <[EMAIL PROTECTED]> [02/07/04 22:10]: > > TODO has: > > * Allow psql \d to show temporary table structure > > Looks like it works fine now with schemas: > > I will mark the TODO as done. It doesn't work with select into though:

[SQL] 7.3 features and enhancements

Hi All, Can somebody direct me to a list of the above. Would be nice to know in advance of its release. Regards Mark ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[SQL] need assistance with multi-row matching expression

different-- to create a successful match for a park_id, I need to check to match against N rows, where N is the number of feature_ids provided. How do I do that? Can I do it in one query? Thanks! -mark http://mark.stosberg.com/ ---(end of broadcast)-

Re: [SQL] need assistance with multi-row matching expression

ture_map map_15 ON (p.park_id = map_15.park_id AND map_15.feature_id=15); In this way, I'm only returned the parks that match all the features. Thanks again for your help! -mark http://mark.stosberg.com/ ---(end of broadcast)--- TI

Re: [SQL] Event recurrence - in database or in application code ????

o be fairly easy to understand and maintain, the SQL that needs to be used ends up being fairly straightforward, and the performance is good because the selects to view the calendar are fairly simple. The one drawback is that sometime before 2028, I have to remember to add some rows to the calendar tab

Re: [SQL] Event recurrence - in database or in application code ????

On 21 Aug 2002, Robert Treat wrote: > On Tue, 2002-08-20 at 22:15, Mark Stosberg wrote: > > > > Hello Darrin, > > > > > > > I've been happy with this solution. I think the Perl turned out to be > > fairly easy to understand and maintain, the SQL

Re: [SQL] Separating data sets in a table

On Sun, 25 Aug 2002, Andreas Tille wrote: > On Sat, 24 Aug 2002, Mark Stosberg wrote: > > > On Thu, 22 Aug 2002, Andreas Tille wrote: > > > Hello, > > > > > > I want to solve the following problem: > > > > > > CREATE TABLE

Re: [SQL] how to refer to tables in another database( or schema)

nd "state code" tables reproduced on many databases throughout an installation. Would anyone recommend either of these solutions, or another one, for addressing this issue? I'm not looking forward to the day when a new country appears, and I have to find all the places I have country

Re: [SQL] Problems with version 7.1, could they be fixed in 7.2?

Hi Ligia, Are you running VACUUM ANALYSE or is it VACUUM ANALYZE (can never remember, though reasonably sure that its the former). Regards Mark Carew Brisbane Australia ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

Re: [SQL] Hairy question - transpose columns

Hi Andres, For mine, I would read the data in using any langauage that I was familiar with and parse it into an array or some other form in the required format then create the "copy" statement for postgresql, connect and apply. Regards Mark ---(end of

Re: [SQL] escape single quote in INSERT command

Hi Hunter, From my xbase++ program suite, sqlcontext class. * cValue := strtran(cValue,['],[\']) * Its called masquarading, simply replace the single quote with back_slash + single quote. Regards Mark Carew Brisbane

Re: [SQL] escape single quote in INSERT command

Woops should have been masquerading ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] import sql script

no ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] Slow self-join on a 100 million record table

and a normal index on TheID. Even with all of this, however, a self-join query like the one just listed takes about 15 seconds on my machine (dual CPU 1.2GHz, 4GB RAM, three 10K rpm SCSI HD w/ RAID-0). Any suggestions? Have I messed up in terms of the SQL statement? Thanks in advance for any help

[SQL] Cancelling Queries

x27;d ask you guys too Mark Mitchell ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[SQL] unsubscribe

unsubscribe ___ Disclaimer: Great Ormond Street Hospital for Children NHS Trust SECURITY WARNING RE: PATIENT OR OTHER CONFIDENTIAL DATA. Please note that Internet E-mail is simply not a secure communication medium. We strongly advise that you understand &

[SQL] function returning setof performance question

talking less than 1/2 a second, but when I've done this sort of thing in Oracle I've seen a performance increase, not a decrease. Any ideas? Thanks folks... I'm new to the list. -- Mark Bronnimann [EMAIL PROTECTED] -- Let's organize t

Re: [SQL] function returning setof performance question

a different SQL statement. Most > functions -- some SQL language based functions are strange this way -- > cannot do this > -- Mark Bronnimann [EMAIL PROTECTED] -- Let's organize this thing and take all the fun out of it. -- ---(end of broadcast)--

Re: [SQL] recursive sql (using the sort_key method)

above 'only' supports 676 children per node. I've never run into that limitation. :) Of course, you could always make each piece of the sort_key longer, if you needed to support more children per node. Mark > > Regards, > > Floyd Shackelford > 4

[SQL] Unsubscribe

please remove my email from your database contacts. Kind Regards, Mark. ___ Disclaimer: Great Ormond Street Hospital for Children NHS Trust SECURITY WARNING RE: PATIENT OR OTHER CONFIDENTIAL DATA. Please note that Internet E-mail is simply not a secure

Re: [SQL] A tricky sql-query...

cify (or generate with application code) all these aliases and joins, though. Sometimes people use this technique to implement tree structures in SQL. Mark -- http://mark.stosberg.com/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] Implementation of a bag pattern using rules

+- (0 rows) Deleting works fine too. Does anyone know how to prevent the problem with the initial insert? I've read 'The Rule System' chapter several times, it's fairly heavy going, and results in much head scratching, but I still can't work out how to fix it. Any

Re: [SQL] Implementation of a bag pattern using rules

Robert Creager wrote: When grilled further on (Mon, 09 Feb 2004 12:42:10 +), Mark Gibson <[EMAIL PROTECTED]> confessed: CREATE RULE bag_abs AS ON INSERT TO bag_test WHERE EXISTS (SELECT 1 FROM bag_test WHERE item = NEW.item) DO INSTEAD UPDATE bag_test SET qty = N

[SQL] timestamptz - problems

serid, enttime, rdset, from); END; ' LANGUAGE 'plpgsql'; ***** Kind Regards, Mark. ___ Disclaimer: Great Ormond Street Hospital for Children NHS Trust SECURITY WARNING RE: PATIENT OR OTHER CONFIDENTIAL DATA.

Re: [SQL] Implementation of a bag pattern using rules

Richard Sydney-Smith wrote: Mark, love the idea, guess I should have read it somewhere but haven't. Obvious and beautiful. Please let me know if you or someone else solves the initial double value. I used to use functions for this kind of thing, and was thinking that what SQL really n

Re: [SQL] Implementation of a bag pattern using rules

Tom Lane wrote: Mark Gibson <[EMAIL PROTECTED]> writes: CREATE RULE bag_rel AS ON INSERT TO bag_test WHERE EXISTS (SELECT 1 FROM bag_test WHERE item = NEW.item) DO INSTEAD UPDATE bag_test SET qty = qty + NEW.qty WHERE item = NEW.item; This can't work because a

[SQL] Date format problems

and thx to those that replied to my previous mail. Many Thanks in advance, Kind Regards, Mark. ___ Disclaimer: Great Ormond Street Hospital for Children NHS Trust SECURITY WARNING RE: PATIENT OR OTHER CONFIDENTIAL DATA. Please note that Internet

[SQL] Tip: a function for creating a remote view using dblink

ames) || '' FROM '' || quote_ident(schema_name) || ''.'' || quote_ident(table_name)) || '') AS rel ('' || trim(trailing '','' from col_defs) || '')''; EXECUTE sql_str; RETURN; END '

Re: [SQL] Date format problems

nd Regards, Mark. >>> Tom Lane <[EMAIL PROTECTED]> 02/16/04 03:34pm >>> "Mark Roberts" <[EMAIL PROTECTED]> writes: > Hi im using the function below to insert data into my db; im using > now() to get the timestamptz, however when inserted in the db the for

Re: [SQL] [HACKERS] Materialized View Summary

he mutable bits! Giving you the best of both worlds. I haven't tried this or thought it through very much - too busy - but I'd thought I'd throw it in for a bit o' head scratching, and chin stroking :) Cheers -- Mark Gibson Web Developer & Database Admin Crom

Re: [SQL] Elegant way to monitor for changes in a trigger and migrate

rested. It needs some cleaning up first, when I have time. -- Mark Gibson Web Developer & Database Admin Cromwell Tools Ltd. Leicester, England. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] create function atof?

Hello, Is it possible to create a database function that mimics the C function atof? I'm guessing it should look something like this: create function atof(varchar) returns float as '??' language returns null on null input;

Re: [SQL] problems using phpPgAmin

? Have you copied 'conf/config.inc.php-dist' to 'conf/config.inc.php' and configured it? BTW, there is a mailing list for phpPgAdmin at: [EMAIL PROTECTED] -- Mark Gibson Web Developer & Database Admin Cromwell Tools Ltd. Leicester, England.

Re: [SQL] Aggregate Function with Argument

STRICT IMMUTABLE; Example: SELECT * FROM array_enum(string_to_array('one,two,three',',')); -- Mark Gibson Web Developer & Database Admin Cromwell Tools Ltd. Leicester, England. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] Explicitly rolling back transaction from within a C-Language function

ation on this subject is also welcome. Thank you for any help, mark __ Do you Yahoo!? The all-new My Yahoo! - What will yours do? http://my.yahoo.com ---(end of broadcast)--- TIP 9: the planner

[SQL] Updating column to link one table to another

linked up yet. I need to know how I can UPDATE the FrequentTable rows, where their infrequentId is zero, to point at the last InfrequentTable entry whose timestamp ts is before its own timestamp ts. Can anyone help me with this? Thank you. - Mark Collette ---(end of

[SQL] Postgres 8 - Database access, new install.

anyone have any idea of how to resolve this problem, I can connect using PGAdminIII but I really would like to be able to login in properly from Command-line also.   Many Thx, Mark. ___ Disclaimer: Great Ormond Street Hospital for Children NHS Trust SECURITY WAR

[SQL] default value for select?

o myColumn if and when "select altColumn ..." returns zero rows? Mark begin:vcard fn:Mark Fenbers n:Fenbers;Mark org:DoC/NOAA/NWS/OHRFC adr:;;1901 South SR 134;Wilmington;OH;45177-9708;USA email;internet:[EMAIL PROTECTED] title:Sr. HAS Meteorologist tel;work:937-383-0430 x246 x-mozilla-html:TRUE

  1   2   >