The data types define the types of data that can be kept in a table column. PostgreSQL provides various data types for different needs. In this post, you will learn about various data types and sizes in PostgreSQL. In addition, you can create your own type in PostgreSQL. Data Types …
A table is made up of rows and columns. After a table is created in a database, the first action a SQL developer takes is to insert data into it to create a new row. One row of data is inserted at a time. To insert data into the PostgreSQL …
One unique feature of PostgreSQL is the ability to insert multiple rows at once with a single command. To insert multiple rows, you need to specify column names and provide a list of rows with comma-separated values in the INSERT INTO command. If a table has an auto-increment field, you …
Epoch time is an industry standard and is used in various API’s and applications. The epoch time is the number of seconds that have passed since January 1, 1970, at 00:00:00 UTC. Epoch time is consistent across various computer systems and is not affected by time zone differences. It only …
PostgreSQL provides a timestamp data type to store date and time data in a table. The PostgreSQL Extract function is used for extracting various date and time fields from timestamp data. You can extract day, month, year, and time information from a timestamp field. The extract function only returns the …
ListView control in WPF is used for display a list of items. Every list view item has its own UI for display its own data. But how every listview item is rendered, it’s depend on the ItemTemplate property of ListView. ItemTemplate property is used for get and set the DataTemplate …
ConcurrentBag is one of the thread-safe collection classes introduced in .NET 4.0. ConcurrentBag allows you to store objects in unordered way. Contrary to ConcurrentDictionary class, it allows you to store duplicate objects. ConcurrentBag allows multiple threads to store the objects. It is optimized for scenarios where same thread act as …
Many readers ask me a question regarding how we can add a tooltip for each item of ComboBox in WPF. Here I am presenting a very simple solution. In the below example, I am creating a simple combobox. ComboBox DataTemplate defines a ListBoxItem for each item in combobox. ListBoxItem has both …
Action is one of the pre-built delegates in C# to store a method reference. The action delegate only accepts those methods that have a void return type. The action delegate has 16 overload methods that allow you to store a method reference that can accept up to 16 parameters. In …
Predicate is a pre-built delegate in the .NET framework class library. Delegates are used to store method which has same parameters and return types as specify in the delegate type. Predicate is a generic delegate. It takes one parameter and returns a boolean value. Predicate delegate is used for check whether a parameter meets …