On Mon, 1 Sep 2003, Alex wrote:
> Hi,
>
> I need to form a query where i can add some columns based on the result.
>
>
> Table A
> ColA, ColB
> --
> 1 A
> 2 B
> 3 A
>
> Table B
> ColC
>
> A
>
> If A exists if would like the result back as
> 1 A OK
> 2 B NG
> 3 A
If I'm understanding you correctly, you can do something like:
select cola,
colb,
exists
(select 'x'
from tableb
where colc = colb)
from tablea
Since that has a subselect, you may get better performance with
something li
Kaarel <[EMAIL PROTECTED]> writes:
[...]
> If these cases are valid, then when does GPL license for MySQL (or any
> other software in that matter) become truly restrictive for a
> proprietary company?
This is neither a GNU nor a MySQL mailing list. I suggest you take
your question to one of tho
Cross-posted to pgsql-advocacy in response to Doug's
comment that:
>This is neither a GNU nor a MySQL mailing list. I suggest you take
>your question to one of those places, as you'll get a better answer.
Responses to pgsql-advocacy... I hate cross-posting, too.
The information is pertinent to p
On Sun, 2003-08-31 at 07:26, Kaarel wrote:
> I don't feel very confident when it comes to software licenses. But
> there are some cases I would like to make myself clear. What I am
> particulary interested in is when does GPL license become restrictive?
> For example say a company has a propriet
On Sun, 2003-08-31 at 11:56, Alex wrote:
> Hi,
>
> I have a query where I want to filter out records from table_a if a
> field in table_a matches in table table_b. Basically table_b defines the
> filter.
>
> If table_b however is empty i dont get any results
>
> SELECT A.value_one FROM table_a
Kaarel writes:
> I don't feel very confident when it comes to software licenses. But
> there are some cases I would like to make myself clear. What I am
> particulary interested in is when does GPL license become restrictive?
> For example say a company has a proprietary software product that only
On Sun, Aug 31, 2003 at 02:26:14PM -0500, Ron Johnson wrote:
> IANAL, but according to my understanding
> (1) proprietary s/w that dynamically links to "GPL" shared libraries
> has not broken the GPL.
Sure? My understanding is that it does break GPL. That's why there's an
LGPL.
But since MySQL is
On Fri, Aug 29, 2003 at 10:37:32AM -0400, Greg Stark wrote:
> Except if it guesses wrong by assuming it isn't selective it would be maybe
> 50% slower doing lots of index lookups instead of a more efficient full table
> scan and join. If it guesses wrong by assuming it'll be very selective as it
>
On Sun, 2003-08-31 at 14:57, Michael Meskes wrote:
> On Sun, Aug 31, 2003 at 02:26:14PM -0500, Ron Johnson wrote:
> > IANAL, but according to my understanding
> > (1) proprietary s/w that dynamically links to "GPL" shared libraries
> > has not broken the GPL.
>
> Sure? My understanding is that it
In the last exciting episode, [EMAIL PROTECTED] (Martin Marques) wrote:
> Is there a possibility to export Btrieve DB files into postgres ??
If you have a tool that can get the Btrieve data out, and turn it into
text, then it is pretty typical for this sort of thing to be quite
achievable using so
On Sat, 30 Aug 2003 16:18:14 +0200 (CEST), [EMAIL PROTECTED] (Peter
Eisentraut) wrote:
>many, but it's usually difficult to get customers to agree to this sort of
>thing.
Why is that?
---(end of broadcast)---
TIP 8: explain analyze is your friend
Oops! Jacob Hanson <[EMAIL PROTECTED]> was seen spray-painting on a wall:
> On Sat, 30 Aug 2003 16:18:14 +0200 (CEST), [EMAIL PROTECTED] (Peter
> Eisentraut) wrote:
>>many, but it's usually difficult to get customers to agree to this sort of
>>thing.
>
> Why is that?
Because:
1. What tools they
The world rejoiced as [EMAIL PROTECTED] (Michael Meskes) wrote:
> On Sun, Aug 31, 2003 at 02:26:14PM -0500, Ron Johnson wrote:
>> IANAL, but according to my understanding
>> (1) proprietary s/w that dynamically links to "GPL" shared libraries
>> has not broken the GPL.
>
> Sure? My understanding is
After a long battle with technology,[EMAIL PROTECTED] (Ron Johnson), an earthling,
wrote:
> On Sun, 2003-08-31 at 07:26, Kaarel wrote:
>> I don't feel very confident when it comes to software licenses. But
>> there are some cases I would like to make myself clear. What I am
>> particulary intere
On Sun, 2003-08-31 at 14:59, Christopher Browne wrote:
> After a long battle with technology,[EMAIL PROTECTED] (Ron Johnson), an earthling,
> wrote:
> > On Sun, 2003-08-31 at 07:26, Kaarel wrote:
> >> I don't feel very confident when it comes to software licenses. But
> >> there are some cases I
Ron Johnson wrote:
> On Sun, 2003-08-31 at 14:57, Michael Meskes wrote:
> > On Sun, Aug 31, 2003 at 02:26:14PM -0500, Ron Johnson wrote:
> > > IANAL, but according to my understanding
> > > (1) proprietary s/w that dynamically links to "GPL" shared libraries
> > > has not broken the GPL.
> >
> > S
17 matches
Mail list logo
