I've followed this list for quite a long time, and I think that I've
discovered a pattern that I would like to discuss.
It seems like there are two camps considering EAV models. On the one
hand, there are researchers who think that EAV is a great way to meet
their objectives. On the other hand,
On Friday 9. October 2009, Scott Marlowe wrote:
>On Fri, Oct 9, 2009 at 8:49 AM, Pedro Doria Meunier
>
> wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> Hi Sam,
>> Thanks for your answer! :)
>>
>> The matter of fact is that the script itself is the connected client
>> where the pos
On Wednesday 5. August 2009, Sam Mason wrote:
>On Wed, Aug 05, 2009 at 11:27:52AM -0600, Scott Marlowe wrote:
>> Otherwise we're blind men describing an elephant.
>
>Interesting analogy, not heard that one before!
http://www.noogenesis.com/pineapple/blind_men_elephant.html
--
Leif Biberg Kristens
On Monday 13. July 2009, Jasen Betts wrote:
>you should wait. 8.4 is in debian now so should be in ubuntu RSN.
One day I'm sure it will even be available in Gentoo.
*sigh*
--
Leif Biberg Kristensen | Registered Linux User #338009
Me And My Database: http://solumslekt.org/blog/
--
Sent via pgsq
On Wednesday 8. July 2009, Scott Marlowe wrote:
>I'm not sure the comments need correction really, although the
>"alleged" bit kind of rubs me the wrong way, but you're not gonna
>convince a MySQL fanboi about anything anyway.
A MySQL fanboi will take offense of the mere fact that anybody will
a
On Saturday 27. June 2009, Merlin Moncure wrote:
>I've noticed over a wide variety of operating systems that when you
>paste from an application into psql through a terminal (currently
>using the default gnome terminal in ubuntu), large pastes tend to get
>garbled with some of the input getting tru
On Friday 19. June 2009, Andrew Maclean wrote:
>I would NEVER run a production server in windows!
>
>These are just laptops/workstations that are used for development e.g,
> when network connections are not available or when travelling.
Both my workstation and laptop have run Linux since 2003, and
On Thursday 11. June 2009, James B. Byrne wrote:
>Given a datetime column, not null, is there a single syntax that
>permits searching for all dates in a given year, year+month, and
>year+month+day such that a single parameterised query can handle all
>three circumstances?
Apart from the other exce
On Thursday 11. June 2009, David wrote:
>When is a good time to use cascading deletes?
As a real world example, I've got a data model that consists of three
major entities: Persons, Events, and Sources. The Events table is
linked to Persons through the junction table Participants, and to the
S
On Saturday 6. June 2009, Grzegorz Jaśkiewicz wrote:
>just change whatever you are storing to be in vertical structure,
>instead of horizontal. so instead of create table foo(a int, b int, c
>int, etc), try:
>
>create table foo(name varchar, val int);
>
>common mistake I've seen committed by people
On Saturday 6. June 2009, DimitryASuplatov wrote:
>Hello,
>
>I am very new to postgresql database. I`ve used a little of MySql
>previously.
>
>My task is to store a lot (10^5) of small ( <10 MB) text files in the
>database with the ability to restore them back to the hard drive on
>demand.
>
>That
On Thursday 4. June 2009, Radcon Entec wrote:
>I have been beating my head against the documentation on plpgsql
> functions with output parameters for the last three hours, but I
> haven't been able to get them to work yet.
>
>
>I am playing with the sum_n_product function, taken from the
> doucmen
On Tuesday 2. June 2009, Anton Marchenkov wrote:
>CREATE OR REPLACE FUNCTION "public"."test_order_by" (sort_key varchar)
>RETURNS SETOF "customers"."customers_with_mark_deleted" AS
>$body$
>DECLARE
> rec RECORD;
>BEGIN
> FOR rec IN SELECT * FROM customers.customers_with_mark_deleted c
>
On Tuesday 2. June 2009, Anton Marchenkov wrote:
>Hi!
>
>I'm trying to use the order by parameter inside a function, but it is
>ignored. Any ideas why? And how can I sort by external parameters
> inside pgsql function?
What's the problem with
SELECT * FROM foo(myvar) ORDER BY sort_key ASC
?
If
On Saturday 23. May 2009, Stefan Keller wrote:
>I have a use case where the I want to put an unforeseable number of
>key/value pairs in a column.
>Now, PostgreSQL has arrays as first class types.
>Are there any best practices and snippets (preferrably in plpgsql) for
>handling key/value pairs?
>--
On Friday 22. May 2009, Alvaro Herrera wrote:
>Hey, if you want to add your functions to
> http://wiki.postgresql.org/wiki/Snippets , that would be great.
+1
--
Leif Biberg Kristensen | Registered Linux User #338009
Me And My Database: http://solumslekt.org/blog/
--
Sent via pgsql-general maili
On Wednesday 20. May 2009, Dave Page wrote:
>On Wed, May 20, 2009 at 7:38 AM, Ivan Sergio Borgonovo
>> oh and yeah... I know a "Tuning Wizard" is evil and will hide all
>> the true unleashed hidden wonderful power you can really squeeze out
>> of Postgresql and corrupt your soul... but still ;)
>
(I sent this message four hours ago, but it hasn't appeared on the list.
I'll make a second try.)
On Wednesday 20. May 2009, Dave Page wrote:
>On Wed, May 20, 2009 at 7:38 AM, Ivan Sergio Borgonovo
>> oh and yeah... I know a "Tuning Wizard" is evil and will hide all
>> the true unleashed hidden
On Wednesday 8. April 2009, Ron Mayer wrote:
>Sam Mason wrote:
>> On Wed, Apr 08, 2009 at 04:56:35PM +0100, Ian Mayo wrote:
>>> One more thing: hey, did you hear? I just got some advice from
>>> Tom Lane!
>>
>> Statistically speaking; he's the person most likely to answer you by
>
>Even so, this
On Thursday 2. April 2009, SHARMILA JOTHIRAJAH wrote:
>Hi,
>Is there a way in Postgres to find when a particular query will
> finish?
>
>For example, for a query like this
>SELECT * FROM TABLE1
>Can we find out from any of the catalog tables(or any other way) when
> this query is likely to complet
(CC'ed to the list)
On Thursday 2. April 2009, linnewbie wrote:
> I am using tcl ( ncgi and tclobdc ) so it is more like the excerpts
> below:
>
>ie I input:
>
>Hello World
>
>xyz
>
>into the text area field, save:
>
>set page_content [ ncgi::value textarea_field_name]
>
>database connect dbh
On Thursday 2. April 2009, linnewbie wrote:
>Hi All,
>
>I'm fairly new to postgres and I'm having this peculiar problem.
>
>I'm storing raw html in a text field and I want users who know HTML to
>update the content in a textarea field.
>
>The problem is postgres is adding braces to the begining and
On Thursday 2. April 2009, Steve Crawford wrote:
>Currently string_to_array(null, ',') yields a null result -
>indistinguishable from string_to_array('',','). Wrapping in coalesce
>does not help distinguish true null input from empty-string input. I'm
>not sure at the moment what other cases exist
On Monday 23. March 2009, Juan Pereira wrote:
>On March 20, I asked for help in the Newbie MySQL forum, got no
> answers.
>
>Then the forum administrator moved the post to the PostgreSQL MySQL
> forum -a forum that deals with PostgreSQL migration issues-, and
> again no answers.
This kind of suppo
On Wednesday 11. February 2009, Leif B. Kristensen wrote:
FYI, I have included the following paragraph in the README.txt:
You're welcome to ask questions about the project provided that they
follow the general guidelines in the article "How To Ask Questions The
Smart Way" <ht
On Wednesday 11. February 2009, Russell Hltn wrote:
>Unfortunately the author doesn't work with Windows and can't help me.
As I have stated in the README.txt, the software is at a very early
stage, and should be considered "proof of concept" or "prototype"
stuff. I have published it "as is" for
On Friday 30. January 2009, Reg Me Please wrote:
>Hello all.
>
>Is there a way to directly access PGSQL from a Javascript application?
>With no application server intervention, I mean.
>Just like libq allows access from C/C++.
The usual way to handle it is to let the JavaScript code call a
server
On Thursday 2. October 2008, Tim Semmelhaack wrote:
>Hello,
>
>I have to import a huge number of data sets of data sets with "Copy
> from".
>
>The numbers are formatted with decimal comma ',' (as usual in Germany)
>instead of the decimal point '.'
>
>When I try to import this data Postgres crashes,
On Friday 19. September 2008, Rainer Bauer wrote:
>I installed 8.3.3 on an english WinXP. The database cluster was
> initialized with server encoding UTF8 and the locale was set to
> 'German, Germany'.
>
>Now all messages in the log and everywhere else are showing up in
> German (as expected). How
On Saturday 26. July 2008, Owen Hartnett wrote:
>Probably some funky stuff with the router (not one of their expensive
>ones) that caused all the consternation, but I originally thought
>corrupt database (because I could get 117 records to come out fine,
>but not the 118th). Also, I had narrowed i
On Friday 25. July 2008, Christophe wrote:
>Most developers don't make deep informed decisions about PHP vs other
>languages. They use it because everyone else is, there is a huge
>ecosystem of support around it, it's easy to get something flopping
>around on the table quickly, and they know *for
On Thursday 24. July 2008, admin wrote:
>It seems that some of PHP's PG functions have changed recently, are
>there any known issues with them?
I've been using PHP with PostgreSQL for 5 years, and haven't noticed any
substantial changes.
>while ($row = pg_fetch_array($query)) {
> $content = $
On Thursday 10. July 2008, Daniel Futerman wrote:
>Hi,
>
>Is there a quick solution to implementing user-defined variables in
>PostgreSQL as they are used in MySQL?
>
>I have the following MySQL script which i want to implement in
> Postgres (NOTE : all ` have been changed to " for Postgres use):
>
On Tuesday 8. July 2008, Raymond O'Donnell wrote:
>On 08/07/2008 13:17, Bernd Helmle wrote:
>> psql uses more to paginate results of your SELECT command. Seems
>> like
>
>Is this the case on both Windows and Linux? - that psql uses more for
>paging, as opposed to doing it itself?
It uses "less" on
On Tuesday 8. July 2008, Long Cui wrote:
>HI
>
>I installed Postgresql 8.3.3 in windows XP, try to input some commands
> in windows command prompt. The create, update and insert command
> work all right, just select command.got the error message: "more" is
> not internal or external command, not
On Monday 23. June 2008, salman wrote:
>This is what I use: SELECT
>pg_size_pretty(pg_database_size(current_database()));
Great, I remember that I saw it, but couldn't remember the command. Now
I've made a function:
CREATE OR REPLACE FUNCTION db_size() RETURNS TEXT AS $$
SELECT pg_size_pret
On Wednesday 11. June 2008, Leif B. Kristensen wrote:
>p := BTRIM(tmp, '#')::INTEGER;
>name := get_person_name(p);
>str := REPLACE(str, tmp, name);
I did some "folding" and replaced the above with
str := REPLACE(str, tmp, get_person_name(BTR
For the record: I've got two different flavors of those "shortlinks".
The first one, [p=123|John Smith] is the one that I started this thread
with. The second one is just a person number like [p=123] and should be
expanded to a similar link, with the default person name (fetched by
get_person_n
On Tuesday 10. June 2008, Michael Fuhr wrote:
>Something between my message and your shell appears to have converted
>a few spaces to no-break spaces. A hex dump of your query shows the
>following:
>
> 73 65 6c 65 63 74 20 72 65 67 65 78 70 5f 72 65 |select
> regexp_re| 0010 70 6c
On Tuesday 10. June 2008, CaT wrote:
>On Tue, Jun 10, 2008 at 03:43:02PM +0200, Leif B. Kristensen wrote:
>> On Tuesday 10. June 2008, Leif B. Kristensen wrote:
>> >Hey, I told it not to be greedy, didn't I?
>>
>> Found it. I must make *both* atoms non-greedy:
&g
On Tuesday 10. June 2008, Leif B. Kristensen wrote:
>Hey, I told it not to be greedy, didn't I?
Found it. I must make *both* atoms non-greedy:
pgslekt=> CREATE OR REPLACE FUNCTION link_expand(TEXT) RETURNS TEXT AS
$$
SELECT REGEXP_REPLACE($1,
I put the code into a function, link_expand():
CREATE OR REPLACE FUNCTION link_expand(TEXT) RETURNS TEXT AS $$
SELECT REGEXP_REPLACE($1,
E'\\[p=(\\d+)\\|(.+?)\\]',
E'\\2', 'g');
$$ LANGUAGE sql STABLE;
pgslekt=> select link_expand('[p=123|John Smith]');
On Tuesday 10. June 2008, Michael Fuhr wrote:
>Parts of the regular expression need more escaping. Try this:
>
>select regexp_replace(
> '[p=1242|John Smith]',
> e'\\[p=(\\d+)\\|(.+?)\\]',
> e'\\2'
>);
>
> regexp_replace
>---
> J
I want to transform the text '[p=1242|John Smith]' to
John Smith, but what I get is:
pgslekt=> select REGEXP_REPLACE('[p=1242|John Smith]',
pgslekt(> E'[p=(\d+)|(.+?)]',
pgslekt(> E'\\2');
regexp_replace
--
[=1242|John Smith
On Friday 16. May 2008, ${spencer} wrote:
>is there a way to write a function without installing a specific
>language? all i need to do is write a function that can take 3 text's
>and put them into a list format (eg. "text1, text2 and text3" )
>
>can anyone help?
sandbox=> create function foo(text
On Wednesday 2. April 2008, Tomasz Ostrowski wrote:
>Go for it. Even 64 (I like round numbers) would not be too much.
Geek test: Do you find the above statement odd?
Yes: 0, No: +10.
(Sorry for being massively off-topic :-))
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solu
On Friday 28. March 2008, josep porres wrote:
>Hi guys,
>
>Is there any other online place, apart from
>http://www.postgresql.org/docs/8.3/static/plpgsql.html ,
>to get a reference or a wider explanation of PL/pgSQL ?
>Do you recommend any book?
I found this page rather useful:
http://www.onlamp.
On Thursday 27. March 2008, Alvaro Herrera wrote:
>Zdenek Kotala wrote:
>> And what about two commands one for create and one for drop?
>> It save 6 or 4 chars.
>>
>> pgc db (as create db)
>> pgc user
>> pgd db (as drop db)
>> pgd user
>
>Well, there are things besides create and drop -- for exam
On Wednesday 26. March 2008, Ron Mayer wrote:
>I'd prefer a "pg" program that took as arguments
>the command. So you'd have "pg createdb" instead
>of "pg_createdb".
>
>There are many precedents. "cvs update", "git pull"
>"apt-get install".
>
>Anyone else like this approach?
I'll second that. It
On Friday 14. March 2008, Adrian Klaver wrote:
> Years ago I played around with MySQL because that
> was what "everybody" was using. The problem was it did not do what I
> wanted and Postgres did.
That pretty much sums up my experiences too. Back in 2002 when I started
fooling around with databa
On Sunday 2. March 2008, Swaminathan Saikumar wrote:
>I am using UTF8 Unicode for most of my data, but there is some data
> that I know for sure will be ASCII. However, this is also stored as
> UTF8, using up more space.
ASCII stored as UTF8 doesn't take up more space than plain ASCII, it's
exact
On Friday 15. February 2008, [EMAIL PROTECTED] wrote:
>Hi all,
>
>I have a large sdf file with many records of molecules and associated
>data items and I want to save them in a PostgreSQL database. There are
>about less than 40 data items for every molecule(the names of the data
>items fore each mo
On Thursday 24. January 2008, Dominique Bessette - Halsema wrote:
>Hello,
>
>How do i find the constraints on a table in SQL? my database is linux
>based, and I cant seem to find the command. Thanks
You should really read the psql documentation:
http://www.postgresql.org/docs/8.2/static/app-psql
me too.
On Wednesday 12. December 2007, Gregory Stark wrote:
>"Alvaro Herrera" <[EMAIL PROTECTED]> writes:
>> Thomas Kellerer wrote:
>>> Joshua D. Drake, 11.12.2007 17:43:
O.k. this might be a bit snooty but frankly it is almost 2008. If
you are still a top poster, you obviously don't ca
On Tuesday 11. December 2007, Andrew Sullivan wrote:
>I don't think top posting is always the crime it's made to be (and I
> get a little tired of lectures to others about it on these lists).
It certainly isn't a crime. But it's a bit like thread hijacking in the
sense that a well-formed inline
On Friday 9. November 2007, rihad wrote:
>It's not an easy thing to do with for example Propel 1.2 ORM (written
> in PHP):
>
>$criteria->addDescendingOrderByColumn(myPeer::LAST_LOGIN); // no place
>to shove database-specific attributes in.
>
>which was my main point.
Which mainly goes to show tha
On Wednesday 15. August 2007, Phoenix Kiula wrote:
>> At least on a *nix system, collation is based on the value of the
>> LC_ALL environment variable at dbinit time. There's nothing you can
>> do about it in a live database. IMO that's a little awkward, and is
>> what finally made me change the gl
On Wednesday 15. August 2007, Phoenix Kiula wrote:
>Couple of questions with porting:
>
>1. I have been playing around with my databases locally on Win XP so
>as not to hurt our website traffic. Now I would like to move the
>database to a Linux CentOS server. Can I use pg_dump on Windows and
>pg_re
On Wednesday 15. August 2007, Phoenix Kiula wrote:
>In some examples posted to this forum, it seems to me that when people
>execute queries in the psql window, they also see "90 ms taken"
>(milliseconds), which denotes the time taken to execute the query.
>Where can I set this option because I'm no
On Wednesday 8. August 2007 15:12, Alban Hertroys wrote:
>You should probably use a trigger (a before one maybe) instead of a
> rule.
I tried that too, but I'm still quite shaky on how to write triggers,
and the same thing happened there: the inserted record was immediately
deleted. I solved the
On Wednesday 8. August 2007 15:12, Alban Hertroys wrote:
>Leif B. Kristensen wrote:
>> CREATE RULE placelimit AS
>> ON INSERT TO recent_places DO ALSO
>> DELETE FROM recent_places
>> WHERE
>> -- this clause doesn't work
>> -- (
I found an excellent description of how to implement a fifo que in
PostgreSQL at Greg Mullane's blog:
http://people.planetpostgresql.org/greg/index.php?/archives/89-Implementing-a-queue-in-SQL-Postgres-version.html
I have used the 'rule' approach to implement a queue that generates a
quick-list
On Wednesday 1. August 2007 18:05, Gauthier, Dave wrote:
>Looking to capture the total number of records affected with
>insert/delete/update from within a plpgsql (v7.4 on linux). Would be
>nice to have this in an integer.
http://www.varlena.com/GeneralBits/23.php
8<-
How many rows were aff
On Wednesday 1. August 2007 16:15, Madison Kelly wrote:
>/Personally/, I love Debian on servers.
>
>It's not quite as 'hardcore' as Gentoo (a great distro, but not one to
>start with!). It's the foundation of many of the popular distros
>(Ubuntu, Mepis, Knoppix, etc) and the Debian crew is very ca
On Saturday 16. June 2007 23:34, Erick Papadakis wrote:
>How much value you derive from a language
>depends on how you use it. After playing for years with Perl, and now
>with Python and Ruby, I think PHP is still where it's at.
I too have played around with Perl and Python, and use both of them f
On Wednesday 13. June 2007 15:45, Tom Lane wrote:
>psql itself has no business touching the database directory, and a
> quick search of the source code shows no instance of "Cannot stat"
> anywhere in released PG sources.
>
>I think you are being burnt by some misbehavior of Debian's wrapper
>patch
On Saturday 2. June 2007 20:39, Ron Johnson wrote:
>You were politely asked not to top-post.
>
>On 06/02/07 11:46, Harpreet Dhaliwal wrote:
>> So, while writing any technical document, would it be wrong to
>> mention stored procedures in postgresql?
>> what is the general convention?
>
>Did I miss
On Saturday 2. June 2007 16:47, Harpreet Dhaliwal wrote:
>Hi,
>
>Is it true that postgres doesn't have a notion of Stored Procedures
> and functions is what it has instead?
>RDBMS like Sql Server supports both stored procedures and functions.
>So I was wondering what is the difference between a Sto
On Thursday 24. May 2007 19:57, Erik Jones wrote:
>On May 24, 2007, at 4:39 AM, Richard Huxton wrote:
>> - unpronounceable name
>
>post-gres-queue-el
Somebody probably wants to put that pot-grass-kewl thing in his pipe and
smoke it.
--
Leif Biberg Kristensen | Registered Linux User #338009
http:
On Wednesday 23. May 2007 16:31, Leif B. Kristensen wrote:
>I've also tried:
>
>pgslekt=> create index last_edit_key on persons(last_edit);
>
>But that doesn't make any difference.
But this one did:
pgslekt=> create index last_edited_persons_key on
persons(las
Can anybody tell me why the following query requires a full table scan?
pgslekt=> explain select person_id, last_edit from persons
order by last_edit desc, person_id desc limit 50;
QUERY PLAN
On Thursday 10. May 2007 21:21, Tom Lane wrote:
>"Leif B. Kristensen" <[EMAIL PROTECTED]> writes:
>> I haven't pondered the subtleties of 'stable', 'immutable' or
>> 'volatile' yet, but rather reckoned that the default would do.
On Thursday 10. May 2007 19:23, Tom Lane wrote:
>"Leif B. Kristensen" <[EMAIL PROTECTED]> writes:
>> CREATE OR REPLACE VIEW tmg_persons AS
>> SELECT
>> person_id,
>> get_parent(person_id,1) AS father_id,
>> get_parent(person_id,2)
On Wednesday 9. May 2007 06:32, Ashish Karalkar wrote:
>Hello All,
>
>Can anybody please point me to Advantages and Disadvantages of using
> view
Sometimes, a view can fool you into writing hideously expensive queries
just because it is the first method that comes to mind.
I upgraded to version
On Thursday 26. April 2007 20:12, Jon Sime wrote:
>I run 8.2.x on a Gentoo/x86_64 development box (just did the upgrade
> to 8.2.4 yesterday) using the postgresql-experimental overlay (via
> layman) and have run into no problems. Everything has compiled,
>installed/upgraded and been run with no hic
On Thursday 26. April 2007 17:10, Joshua D. Drake wrote:
>> Actually, I've a feeling that it would be trivial to do with just
>> about any existing packaging system ...
>
>Yes pretty much every version of Linux, and FreeBSD, heck even Solaris
>if you are willing to run 8.1.
Gentoo is still on vers
On Wednesday 11. April 2007 19:50, Andrew Edson wrote:
>I'm needing to do a partial dump on a database. All of the entries in
> the db can be marked as one of two groups, and I've been asked to
> create a dump of just the second group. It is possible to do a
> select statement based dump and just
On Friday 16. February 2007 07:10, Tom Lane wrote:
> Perhaps this
> paper can be described as "comparing an F-15 to a 747 on the basis of
> required runway length".
There ought to be a proper name for this kind of pseudo-technical Gonzo
journalism. The Internet is full of it.
--
Leif Biberg Kri
On Friday 8. December 2006 16:23, Raymond O'Donnell wrote:
>Just wondering.how do list member represent gender when storing
>details of people in a database?
>
>I've done it two ways:
>
>* A bool column, with the understanding that true/false represents
>one gender or the other.
>
>* Create a d
On Thursday 9. November 2006 09:34, Richard Ollier wrote:
>Hello,
>
>For a project I have a table containing products and flags.
>The columns of this table are of 2 kinds :
>- Not null data (id, column1, column2)
>- Flags (100 different flags set to 1 or 0)
>
>Over the time the number of flag will
On Monday 30. October 2006 10:31, Ashley Moran wrote:
>On 30 Oct 2006, at 06:15, Nikolay Samokhvalov wrote:
>> Could you please give some example of such "inspired by MySQL
>> features of PHP design"?
>
>Sorry... perhaps I should have wrapped my comment in bitterness="10"/> to make it more clear w
On Thursday 14. September 2006 17:27, Arturo Perez wrote:
>Hi all,
>
>Any response to this:
>http://www.internetnews.com/dev-news/article.php/3631831
I submitted the story to Slashdot:
http://it.slashdot.org/article.pl?sid=06/09/15/1412249
In the /. discussion, Rasmus Lerdorf himself claims that
On Wednesday 12. July 2006 21:03, Marco Bizzarri wrote:
>
>Long term archival of electronic data is a BIG problem in the
>archivist community. I remember, a few years ago, a paper describing
>the problem of historical (20+ years old) data which were running the
>risk of being lost simply because of
On Tuesday 11. July 2006 15:22, Alvaro Herrera wrote:
>Leif B. Kristensen wrote:
>> It would be nice, though, if we had something like Oracle's
>> SQL-Loader for PostgreSQL. It's a very powerful tool for
>> transforming and loading data.
>
>We do have very po
On Tuesday 11. July 2006 10:10, A. Kretschmer wrote:
>Do you have a UNIX-like operating system? Then you can use tools like
>'cut':
>
>[EMAIL PROTECTED]:~$ echo "s1,s2,s3" | cut -d ',' -f 1,3
>s1,s3
>
>This result can you pipe into psql.
It would be nice, though, if we had something like Oracle's
On Friday 30. June 2006 17:12, Scott Marlowe wrote:
>And, I hate the fact that CTRL-C in the mysql command line tool exits
>the tool instead of interrupting the current query.
I agree, it's a nuisance.
>In PostgreSQL it
>interrupts the current query. CTRL-\ will kill the client if you need
>
On Wednesday 28. June 2006 21:33, Karsten Hilbert wrote:
>On Wed, Jun 28, 2006 at 06:25:22PM +0200, Leif B. Kristensen wrote:
>> >> event_date CHAR(18) NOT NULL DEFAULT
>>
>> The event_date field is a "fuzzy date" construct. It will allow the
&g
On Wednesday 28. June 2006 17:37, David Fetter wrote:
>On Wed, Jun 28, 2006 at 05:14:42PM +0200, Leif B. Kristensen wrote:
>> On a tangent to the never-ending NULL debate, I've got a table:
>>
>> CREATE TABLE events (
>> event_idIN
On a tangent to the never-ending NULL debate, I've got a table:
CREATE TABLE events (
event_idINTEGER PRIMARY KEY,
tag_fk INTEGER REFERENCES tags (tag_id),
place_fkINTEGER REFERENCES places (place_id),
event_date CHAR(18) NOT NULL DEFAU
On Wednesday 14. June 2006 11:38, Martijn van Oosterhout wrote:
>Have a nice day,
I forgot to say thank you. And a nice day to you too.
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE
---(end of broadcast)---
On Wednesday 14. June 2006 11:38, Martijn van Oosterhout wrote:
>Why did you put parenthesis there? It looks like you're making a
> record within a record. You wouldn't have parenthesis there for a
> normal select statement, would you?
s**t. When I remove the parentheses, it runs fine.
This is a
On Wednesday 14. June 2006 11:09, Martijn van Oosterhout wrote:
>IIRC, if you just declare src as type "record" you can select any
>fields you like. AIUI, declaring a row to be of a specific type is
> only really important if you plan to return it or pass it to another
> function.
I tried:
CREAT
On Wednesday 7. June 2006 00:10, Jim C. Nasby wrote:
>Also, the commentary about how MySQL is faster isn't very clear. Are
> you using MySQL as some kind of result cache? When you get to running
> actual concurrent access on the website, you could well find yourself
> very disappointed with the pe
On Tuesday 13. June 2006 15:39, jqpx37 wrote:
>I'm working on a project involving PostgreSQL and Apache.
>
>Anyone know of any good books or online how-to's on getting PostgreSQL
> and Apache to work together? (I'm also using PHP.)
AFAIK, there are no dependencies beween Apache and PostgreSQL. PH
On Wednesday 7. June 2006 06:26, Robert Treat wrote:
>On Tuesday 06 June 2006 18:44, Leif B. Kristensen wrote:
>> The reason why the generation of eg. the family sheet is faster in
>> the MySQL web context than in my production environment, is that I'm
>> really com
On Wednesday 7. June 2006 00:10, Jim C. Nasby wrote:
>Moving to -general.
>From the bottom of that page:
>
>SELECT * FROM sources INTO src WHERE source_id = $1;
>
>SELECT * is generally something to avoid. You end up shoving around
> more data than needed. Granted, in this case it's only gettin
On Thursday 1. June 2006 16:18, Antonios Katsikadamos wrote:
>Hi all again. sorry for the disturbance but I am not aware of the
> postgres installation procedure. my laptop runs Win xp on format
> fat32. I get a message from installation
>that requires NTFS format. Is there a way of installing post
On Thursday 04 May 2006 23:06, Jim C. Nasby wrote:
>On Thu, May 04, 2006 at 10:58:24PM +0200, Leif B. Kristensen wrote:
>> On Thursday 04 May 2006 22:30, Jim C. Nasby wrote:
>> >I believe transactions are limited to 4B commands, so the answer
>> > would be 4B rows.
>&
On Thursday 04 May 2006 22:30, Jim C. Nasby wrote:
>On Wed, May 03, 2006 at 04:28:10PM +0200, Leif B. Kristensen wrote:
>> However, I'm wondering if there's a practical limit to how many rows
>> you can insert within one transaction?
>
>I believe transactions are
On Wednesday 03 May 2006 16:12, Larry Rosenman wrote:
>Javier de la Torre wrote:
>> It is inserts.
>>
>> I create the inserts myself with a Python programmed I hace created
>> to migrate MySQL databases to PostgreSQL (by th way if someone wants
>> it...)
>
>Ok, that makes *EACH* insert a transactio
1 - 100 of 117 matches
Mail list logo
