All Questions
551
questions
1
vote
0
answers
29
views
Is it necessary to create duplicate type definitions for data when using Diesel ORM in Rust? [duplicate]
I am starting to use the Diesel ORM for an application, and am confused about the necessary steps described in the official getting started guide.
It seems like the ORM first requires to create type ...
0
votes
2
answers
80
views
How to create the value of `SETOF <sometype>` type by hand in PostgreSQL?
PostgreSQL has SETOF <sometype> type according to the doc and SETOF <sometype> type is used in a function as shown below:
-- ↓ ↓ ↓ Here ↓ ↓ ↓ ...
0
votes
0
answers
20
views
Handling Type Error for Database-Generated Fields in Python API Application
I have a Python application with an API that interacts with a SQL database. The API allows users to perform various operations, and the results are stored in the database. I'm currently facing an ...
1
vote
0
answers
49
views
SQL data precedence in CASE statements
This is kind of a silly question, but can someone explain how SQL handles different numerical data types in case statements?
For example, what happens to the following if t.val is a float data type?
...
0
votes
1
answer
92
views
Converting number property into words using SQL in Oracle
I am trying to convert a prop into words using this:
to_char(to_timestamp(lpad(123456, 9, '0'), 'FF9'), 'Ffsp') amount,
This works, but I want to replace 123456 with a dynamic property.
My prop is
l....
-1
votes
2
answers
62
views
STR_TO_DATE in mariaDB results in NULL
I have a table with more than 150k entries. The date column contains dates in german format (day.month.year). I can't set 'DATE' as datatype - maria don't accept this format. So I tried to reconfigure ...
0
votes
1
answer
217
views
A procedure supposedly does not exists
I'm trying to make a PostgreSQL system that simulate transfers between 5 banks. But I have a problem that I really do not manage to understand. PostgreSQL seems to not understand the types of my data (...
0
votes
1
answer
142
views
Oracle SQL. User defined function will not run in SELECT statement, but will run if wrapped in procedure
I have an oracleSQL database over a voter register. To check if a voter has previously voted I created a function PreviouslyVoted(election_code, electorate_code, voter_id) seen below.
create or ...
0
votes
1
answer
26
views
CHanging the data type from text to date in a column
i have a table named players_wc where there is a column name Player_DOB whose data type is text.
the values inside the column are like 02-09-1992. i need to change the data type of the column in order ...
0
votes
1
answer
66
views
SQL UNION on different column lengths and data types
I have two tables
CREATE TABLE LOGIN
(
[ID] INT NOT NULL IDENTITY(1,),
PASSWORD VARCHAR(30) NOT NULL,
CONSTRAINT [PK] PRIMARY KEY ([ID] ASC)
)
CREATE TABLE HASH
(
PSWDHASH VAR(100) ...
0
votes
0
answers
59
views
Prevent a case-when-expression to change the result type
I'm processing the results of a select statement in Java using JDBC. In the select statement I have the following expression where x is a column:
case when <some-condition> then x else null end
...
0
votes
1
answer
139
views
Dask dataframe sql_read of a mariadb database got " IntCastingNaNError: Cannot convert non-finite values (NA or inf) to integer"
I have a read_sql_query which retrieves a Dask Dataframe. This issue is in the table I have Nan/None values and I am trying to convert to 0, so that I can export it to csv. When I try I get a "...
1
vote
1
answer
23
views
sql related in importation and creation of tables
Am importing my sql from the htdocs folder in xampp but this table aint runing due to some error which i can't seem to identify
CREATE TABLE `product_list` (
`id` int(30) NOT NULL,
`vendor_id` int(...
0
votes
1
answer
243
views
Postgresql max time value
In the postgresql documentation related to date/time types. It is stated that the type time can have a max value of 24:00:00. Can someone could explain to me the purpose of settings this value to ...
0
votes
1
answer
233
views
How to have a column set to a custom type?
I am new to using SQL and relational databases. I am creating a basic quiz web app where people can create their own quizzes and have all the data stored in a cloud SQL database. All of this works ...