Questions tagged [record]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
2answers
321 views

How to get the column names of a RECORD?

I have a function that declares: DECLARE r RECORD; The data on this record varies and at some point I need to know the column names. How do I get the column names of a RECORD in another record ?
2
votes
1answer
58 views

Return both one value and one column from pl/pgsql function

I wish my pl/pgsql function to go fetch and return two informations in my database in a single connection: one vector containing data whose type is unknown at call time (an array) one string value ...
3
votes
0answers
412 views

Best way to cast array (text[]) to record-type?

PostgreSQL has the ability to create record types. A lot of operations like regexp_match return text[]. What is the most efficent way to go from text[] to a custom record type? Currently, I'm doing ...
1
vote
3answers
58 views

Record doesn't show if selecting earlier date interval

i encountered a very strange behaviour on mysql database. I have this complicated query: SELECT category, subcategory, sum(hours), count(hours), group_concat(concat(user,': ', comment) ...
3
votes
0answers
857 views

SQL Server: ODBC Linked Server to Oracle does not return all rows

Let's say we have one SQL Server instance on one side: SQL Server 2008 R2 SP3 Oracle 11.2 client installed with OLEDB Drivers for ODBC .. and an Oracle database instance on another side: Oracle ...
-1
votes
1answer
142 views

Generating Record Ids in Postgres [closed]

Using the UUID data type with its 256 chars seems like overkill, while assigning an auto-increment int4 seems less robust. Is there a more robust way to assign a record id without using uuid or an ...
2
votes
1answer
204 views

How to estimate the storage needed for a database?

I ran across this questions trying to dive into a computer measurements worksheet online and for the life of me could not figure it out. This is the question: Assume each record in a database ...
1
vote
0answers
76 views

How to use the value from record like as varchar?

I'm trying update a old table with result of selec for another tables but get a error using this sintaxe (e.g.): DO $$ DECLARE _roles refcursor; _onerole varchar; _record RECORD; ...
0
votes
1answer
3k views

PL/SQL cursors and records

I am a new to Pl/sql and I need to learn to write simple pl/sql scripts. Is there any difference between cursors and records in PL/sql? So far I find them both similar.
0
votes
1answer
2k views

Change the row position of a record without messing anything else MySQL?

Hi I would like to ask if there is a smart way to change the record position of a table in mysql. My problem is this: I have a table with statistics data and when I recover all the details in a table ...
7
votes
2answers
6k views

Insert RECORD into a table in a trigger function

I would like to insert a RECORD data type variable (NEW variable) into a table in a trigger. What would the SQL look like? The following attempts were unsuccessful: EXECUTE 'INSERT INTO my_table ...
3
votes
2answers
19k views

Insert values from a record variable into a table

I am developing a user-defined function that takes two arguments: create or replace function gesio( events_table_in regclass, events_table_out regclass) returns void as $$ ... $$ ...
1
vote
1answer
866 views

Implementing a Record Keeper/Rollback System for a MySQL Database

What's the best way to create a record keeping table for all actions in my database? I have a number of tables inside one database and I want to create another that records all movements in every ...
1
vote
1answer
4k views

Difference between return next and return record

What is the difference between RETURN NEXT and RETURN RECORD in PL/pgSQL? I find the manual quite confusing in explaining what RETURN RECORD actually does. What is a RECORD type?
1
vote
1answer
366 views

Mysql setting a record as deleted or archive

Is there any way to omit some records in mysql select statement and not deleting them? We can easily add a column for example deleted and set it to 1 for deleted ones and keep them but the problem is ...
11
votes
1answer
234 views

What platform for a large record based mathematical database?

Hi I am a civil engineer with some experience of programming but I am not familiar with the vast range of options available today. Hope you could give me any pointers the best way to proceed. I want ...
56
votes
8answers
25k views

What is the difference between a “record” and a “row” in SQL Server?

There was a rather innocuous question about adding dates and times in SQL Server that set off a rather fascinating taxonomic debate. So how do we differentiate between these related terms and how we ...