Re: Support for "NOT EXISTS" available?

2018-10-28 Thread genc
Thank you so much, Jeremy. On Tuesday, October 23, 2018 at 5:46:47 PM UTC+3, genc wrote: > > Hi Jeremy, > > I dig into querying.md and can't find any example about "NOT EXISTS". > > How can we write this query in Sequel: > > select * from books where not exists (select * from writers where

Re: Support for "NOT EXISTS" available?

2018-10-23 Thread Jeremy Evans
On Tuesday, October 23, 2018 at 8:52:10 AM UTC-7, genc wrote: > > Thank you, Jeremy! It did worked. > > One last question. About migrations. I have a few foreign keys already > declared and they are set to "on delete SET NULL". I would like to change > them to "on delete CASCADE". I know there

Re: Support for "NOT EXISTS" available?

2018-10-23 Thread genc
Thank you, Jeremy! It did worked. One last question. About migrations. I have a few foreign keys already declared and they are set to "on delete SET NULL". I would like to change them to "on delete CASCADE". I know there was a way of doing this but alter_table seems not mentioned about this.

Re: Support for "NOT EXISTS" available?

2018-10-23 Thread Jeremy Evans
On Tuesday, October 23, 2018 at 7:46:47 AM UTC-7, genc wrote: > > Hi Jeremy, > > I dig into querying.md and can't find any example about "NOT EXISTS". > > How can we write this query in Sequel: > > select * from books where not exists (select * from writers where .) > > I doubt NOT EXISTS

Support for "NOT EXISTS" available?

2018-10-23 Thread genc
Hi Jeremy, I dig into querying.md and can't find any example about "NOT EXISTS". How can we write this query in Sequel: select * from books where not exists (select * from writers where .) Thanks, Gencer. -- You received this message because you are subscribed to the Google Groups