I'm getting lots of delimited files from Excel and MySQL users that,
mid-file, begin truncating lines if ending in null values.
for example:
1781: "one","two","three",,
1782: "one","two","three",,
1783: "one","two","three",,
(delimited files from Open Office are well behaved)
is there any wa
On Sep 23, 2007, at 11:56 PM, Erik Jones wrote:
On Sep 21, 2007, at 6:16 PM, Stefan Arentz wrote:
Well I'm just toying with an idea. The problem I'm facing is that I
would like clients to only see the tuples that they have created and
own. I guess I'll just skip direct sql access to the db a
Dear users,
I'm trying to create constraints into a db they give me from access...
I'm using pgadmin to create a new foreign key for the relationship
between two table..
I have a table called "generalita" wich contains a column called
"cod_carg":
___
select cod_carg from generalita
> On 23/09/2007, Matt Magoffin <[EMAIL PROTECTED]> wrote:
>> Hello,
>>
>> My SQL skills are limited and I'm struggling with a query where I want
>> to
>> return a single item of an aggregate join. The query looks like this:
>>
>> select
>> (case
>> when agg.avg_rating is null then 0.0
>>
