Comments (3)
That was it. Still getting used to DBeaver which tries a little too hard to be helpful sometimes.
I know SQL Server doesn't support tuples, but maybe some others do.
I suppose this could be implemented and it could be up to the user to know if tuples are not supported.
Or maybe it would be worth converting the tuples to AND
queries for SQL Server.
from sqlhydra.
Is that valid in PostgreSQL? I tried this query using the SqlHydra.Npgsql test database but it gives a syntax error:
select e.*
from humanresources.employee e
(jobtitle, maritalstatus) = ('Design Engineer', 'M')
However, this works:
select e.*
from humanresources.employee e
where jobtitle = 'Design Engineer' and maritalstatus = 'M'
from sqlhydra.
The first one is missing a where
?
This should work
sample=# with t as (select 1 as f, 2 as s) select * from t where (t.f,t.s) = (1,2);
f | s
---+---
1 | 2
(1 row)
It does work with string too. It is especially handy working with comparing multiple operators i.e less than/greater than, since the expanded form is bit lengthy.
from sqlhydra.
Related Issues (20)
- Types for views are not generated HOT 4
- Error when using use ctx = openContext() HOT 4
- Support for cancellation token in db operations HOT 5
- Adding Postgres' "UPSERT" to SqlHydra HOT 4
- sqlhydra-npgsql generation tool doesn't pick up "enum" columns HOT 12
- SqlHydra.Npgsql code gen fails when custom enum is not in `public`
- Generate types in separate module HOT 7
- MSSQL (Microsoft.Data.SqlClient): can't retrieve DateOnly HOT 10
- Finish support for DateOnly/TimeOnly types
- Cutting off DateTime precision? HOT 11
- .net6 DateOnly issues in an Update statement HOT 2
- Joining more than once on the same table produces invalid SQL HOT 12
- SQL Lock Tables HOT 3
- sqlhydra-npgsql generation tool doesn't pick up "array" columns HOT 10
- SqlServer: Cannot use `getId` against a `UNIQUEIDENTIFIER` column HOT 6
- Question about multiple inserts, possibility to not enforce the "match"? HOT 5
- `SqlHydra.ProviderDbType` Attribute requires SqlHydra.Query HOT 1
- User Defined Functions/ Table Valued Functions HOT 12
- Add support for dotnet 7 HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlhydra.